Registered aircraft · 18,497

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N253CDAngell John C · Ann Arbor, MIBuilt 2003 · S/N 0448 N253KTInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N E2200 N253RLArs Automation Design Inc · Greensboro, NCBuilt 1980 · S/N EA-131 N253WCba Investments LLC · Kalispell, MTBuilt 2004 · S/N 0881 N2540THenningsen Air LLC · Atlantic, IABuilt 1970 · S/N NAV-4-2540 N2541XEco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N P2060041 N25466Bas Part Sales LLC · Greeley, COBuilt 1986 · S/N E-2303 N2547XOber John A · Candor, NYS/N P206-0047 N254CMGatewood Crisp · Tifton, GABuilt 1975 · S/N 310R0254 N254DBBurns Darryl E · Salinas, CABuilt 2002 · S/N 0157 N254DPPulsipher David · Saint George, UTBuilt 1990 · S/N E-2527 N254PBNicole Business Group LLC · Hooks, TXBuilt 1982 · S/N 340A1504 N254SWalker Curtis · Lake Havasu, AZS/N 21061198 N254TM56h LLC · St Simons Island, GABuilt 1979 · S/N 414A0254 N254TSGiesbrecht Nolan R · Burns, ORBuilt 1974 · S/N U20602381 N254WGMccauley Thomas I · Puyallup, WABuilt 1978 · S/N 18503572 N2550SGrewal Amritpal S · Stockton, CAS/N 21061326 N2550TTropical Airways LLC · West Palm Beach, FLBuilt 1972 · S/N NAV-4-2550 N2551TIllinois Aviation Inc · Englewood, FLBuilt 1970 · S/N NAV-4-2551 N2551XMcgrath Paul · Potsdam, NYBuilt 1965 · S/N P206-0051 N2552XN2552x LLC · Boulder, COBuilt 1964 · S/N P206-0052 N2553TDavis David F · Oregon, ILBuilt 1974 · S/N 2553 N2554TAlvion LLC · Unionville, INBuilt 1975 · S/N NAV-4-2554 N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054 N2555TFrez Raymond · Jacksonville, FLBuilt 1975 · S/N NAV-4-2555 N2556XHusnik Brad M · Forest Lake, MNFirst renewal noticeBuilt 1964 · S/N P206-0056 N2557TSouthwest Aircraft LLC · Fairacres, NMS/N NAV-4-2557 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2559JStuder Alfred C · Shelby, MIBuilt 1979 · S/N T18803482T N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N255BABgp Realty Inc · Boca Raton, FLBuilt 1967 · S/N TE-364 N255BSScheeler Gerard M · Granbury, TXBuilt 2001 · S/N 0069 N255MAKmco Inc · Lenexa, KSBuilt 1967 · S/N TE-318 N255XMS-Tee Corp · Mineri Wells, TXBuilt 1966 · S/N TE-263 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N25612Mad Scientist Aviation LLC · Wilmington, DES/N TE-897 N25615Roark Co Inc · Montgomery, ALBuilt 1973 · S/N E-460 N2561TBlumenstock Kenneth A · Culpeper, VABuilt 1976 · S/N NAV-4-2561 N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061 N25625Martinez Maurice Dominic · La Habra, CABuilt 1973 · S/N E-393 N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295 N25632Struck Larry G · Gardnerville, NVS/N D-9435 N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438 N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330 N2563ZWien Richard A · Fairbanks, AKBuilt 1963 · S/N 185-0563 N25642Pester Jerome B · Hingham, MTBuilt 1973 · S/N CE-457 N25647Segura Richard J III · Henderson, TXBuilt 1973 · S/N TH-301 N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522 N25665Franks Bryan · Camarillo, CABuilt 1973 · S/N CE-459 N25667Bushnell Alison M · Phelan, CABuilt 1973 · S/N E-468

Back to AD 86-13-04 R3