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.

N54LLRyan Good Aviation LLC · Sioux Falls, SDBuilt 1968 · S/N 185-1463 N54MMGwinn Roger A · Maple, NCBuilt 1979 · S/N 21063756 N54PFSilverado Land Management LLC · Sparks, NVS/N E-2941 N54PSAustin Bill DBA · Sparta, TNBuilt 1980 · S/N P21000492 N54RAerometrix LLC · Lawrence, KSBuilt 1981 · S/N 21064514 N54TCK K Stevens Publishing Co · Astoria, ILBuilt 1976 · S/N CE-661 N54TTRedcell Air Inc · Miami, FLBuilt 1981 · S/N 421C1054 N54VKPain Management And Aesthetics LLC · Celina, OHBuilt 1966 · S/N D-8066 N54WMNemensky Jack · Southborough, MABuilt 1976 · S/N CE-657 N5500FVernon Walter Benson · Denver, COBuilt 1989 · S/N CE-1400 N5504MDaniel Richard L · La Habra Heights, CABuilt 1967 · S/N 375 N5507MVasenden Arnold V · Midlothian, TXBuilt 1967 · S/N 378 N550AFAtm One Inc · Tulsa, OKBuilt 1979 · S/N EA-6 N550BNAllen Anne · Huntsville, TXBuilt 1977 · S/N 18265609 N550BRF P And P I Enterprises Inc · Oceanside, CABuilt 1974 · S/N 414-0533 N550CBCarnevale Philip A · Lake City, FLBuilt 1978 · S/N TE-1135 N550CDCoen Scott D · Kingsport, TNBuilt 2004 · S/N 1124 N550CVGoodwin-Huber-Wilhelm Linda Lee · Santa Fe, NMBuilt 1973 · S/N D-9505 N550DDSaratoga Aviation LLC · Rocky Mount, NCBuilt 1996 · S/N 32-46037 N550FK38884 LLC · Moorhead, MNBuilt 1977 · S/N 18503229 N550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingBuilt 1968 · S/N 401-0289 N550GRClark Robert E · Meridian, MSBuilt 2001 · S/N 40015 N550JKTaffet Jay · New Orleans, LABuilt 1986 · S/N 46-8608041 N550JRUrban Cowboy Aviation LLC · Richland, NEBuilt 1990 · S/N CE-1449 N550KBPradelt Charles · Queen Creek, AZBuilt 2001 · S/N ES-126-FB N550LMAdventure Day Aviation LLC · Greensboro, NCBuilt 1990 · S/N CE-1472 N550LWWasserott Charles G · Owasso, OKBuilt 2001 · S/N ES 116 N550MBRegistered aircraftBuilt 1964 · S/N D-7610 N550MGGriggs Matthew J · Tunkhannock, PABuilt 1981 · S/N U20606173 N550MHAviation Education Services Inc · Tetonia, IDS/N 11790-2 N550NCTri-State Communications Inc · South Sioux City, NEBuilt 1988 · S/N CE-1241 N550RESimply Living LLC · Fort Myers, FLBuilt 1974 · S/N 21060968 N550RGBr Ventures LLC · Port Orange, FLBuilt 2005 · S/N 1635 N550RJHovermale Ken · Portland, MEBuilt 1989 · S/N E-2516 N550RWNine Six Livestock Co · Sterling City, TXBuilt 1972 · S/N 18502015 N550SNortheast Cubs LLC · Wilmington, DEBuilt 1976 · S/N 340A0086 N550X550x LLC · Tucson, AZS/N D-9255 N550YRFriedman Michael S · Chantilly, VABuilt 1981 · S/N TE-1196 N5510MPatterson Philip Allen · Ailey, GABuilt 1967 · S/N 381 N5511CDss Consulting LLC · Omaha, NEBuilt 1979 · S/N 21063772 N5511MSoodoo Mark A · Charlestown, INBuilt 1967 · S/N 382 N5515CIsland Fliers LLC · Sheridan, WYBuilt 1982 · S/N T30300142 N5516CCarson Kirk · Dalhart, TXBuilt 1979 · S/N 21063774 N5517UKoegel John C · Flint, MIBuilt 1984 · S/N 21064897 N5518ERomeo Charley LLC · Boulder, COBuilt 1979 · S/N 18503988 N5519ABiersack Alexander J · BerlinBuilt 1989 · S/N CE-1337 N5519UBurlington Veterinary Systems LLC · Burlington, KSBuilt 1990 · S/N E-2519 N551BW602 Xx LLC · Springdale, ARBuilt 1990 · S/N CE-1431 N551CDBwr Group LLC · Hobbs, NMBuilt 2005 · S/N 1550 N551DBKirby Ramsey Aviation Group LLC · Almont, COBuilt 1998 · S/N E-3158

Back to AD 86-13-04 R3