Registered aircraft · 896

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:99-15-04-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-15-04-R1') 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:99-15-04-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-15-04-R1')
  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:99-15-04-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-15-04-R1')
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.

N804AFBlue Pearl Ventures LLC · Eighty Four, PABuilt 2021 · S/N 4636791 N804CSalcedo Eduardo · San Diego, CABuilt 2013 · S/N 4636602 N808WYTriple B Aviation LLC · Kalispell, MTBuilt 2012 · S/N 4636536 N809CJl & R Aviation LLC · Hays, KSBuilt 2010 · S/N 4636485 N80RLGree LLC · Hobbs, NMBuilt 2014 · S/N 4636646 N80ZZKenmore Crew Leasing Owner Trustee · Bellingham, WABuilt 1984 · S/N 46-8408061 N812MBOeth Laurence B III · Midland, TXBuilt 1997 · S/N 4636111 N814TFRsb 2.0 LLC · Wilton, CTBuilt 2012 · S/N 4636552 N816JGPie Haven LLC · Fort Lauderdale, FLBuilt 2016 · S/N 4636696 N816TPDefense Research Institute Inc · Fayetteville, NCBuilt 2012 · S/N 4636529 N817MJSmt Services LLC · Archie, MOBuilt 2016 · S/N 4636700 N818JPN818jp LLC · Los Angeles, CABuilt 1984 · S/N 46-8408047 N822MBLx7 Air LLC · Newark, DES/N 4608086 N827RJN827rj LLC · Ogden, UTBuilt 2012 · S/N 4636526 N828GPGreene And Phillips Attorneys At Law LLC · Mobile, ALBuilt 2011 · S/N 4636514 N828PMRobinson Shannon D · Fair Oaks Ranch, TXBuilt 1987 · S/N 4608057 N829CGRegistered aircraftBuilt 1986 · S/N 4608029 N829KAMccallum Aviation LLC · Chehalis, WABuilt 2012 · S/N 4636530 N82KFAtlantic Aviation Services LLC · Cheyenne, WYBuilt 2015 · S/N 4636677 N82LLSda Aviation LLC · Winnsboro, LABuilt 2000 · S/N 46-36289 N830MOliver Firm Lc · Dexter, MOBuilt 1989 · S/N 4622045 N830TPValhalla Partners LLC · Atlanta, GABuilt 1984 · S/N 46-8408015 N831CPeck Aerospace LLC · Westminster, MDBuilt 2011 · S/N 4636492 N83ECCarter Associates Inc · Sturgis, MIBuilt 2000 · S/N 4636307 N83VSTvpx Aircraft Solutions Inc · North Salt Lake, UTBuilt 2024 · S/N 4636846 N840DElusive Aviation Inc · Pflugerville, TXBuilt 1987 · S/N 4608076 N844BCJ&B Technologies LLC · Kalispell, MTS/N 4636293 N844TPoukish John J Jr · Edwards, COBuilt 1989 · S/N 4622025 N852SGPeninsula Wings LLC · Sunny Isles Beach, FLBuilt 2024 · S/N 4636854 N858TDC J Flyin LLC · Salt Lake City, UTBuilt 2013 · S/N 4636601 N85PGN85pg LLC · Atlanta, GABuilt 1985 · S/N 46-8508066 N85RTJetprop Aviator LLC · Lewes, DEBuilt 1985 · S/N 8508033 N860FGCapital Holdings 299 LLC · Edwards, COBuilt 2025 · S/N 4636860 N861DPPoage Equipment LLC · Amarillo, TXBuilt 1996 · S/N 4636058 N863WAK Bear Holdings LLC · Bend, ORBuilt 2025 · S/N 4636863 N864JBBas Part Sales LLC · Greeley, COBuilt 1986 · S/N 4608009 N869MErw Aviation LLC · Marshall, TXBuilt 2010 · S/N 4636476 N870FSLindsey Norman A · Richardson, TXBuilt 1987 · S/N 4608051 N872AFArmstrong Jay DBA · Muscotah, KSBuilt 2013 · S/N 4636598 N872RJ&J Surveying & Leasing LLC · Jacksonville, FLBuilt 1989 · S/N 4622028 N875FGFlightline Group Inc · Tallahassee, FLBuilt 2026 · S/N 4636875 N8762BRmp Capital LLC · Dubois, PABuilt 2015 · S/N 4636662 N87PBH Kyle Sheets Md Pa · Ovalo, TXBuilt 2022 · S/N 4636804 N87RDDougs Glass Shop Inc · Bridgewater, CTS/N 46-08069 N880BTw880b Leasing LLC · Farmington, UTBuilt 2021 · S/N 4636788 N881DBJetprop Holdings LLC · Santa Fe, NMBuilt 1989 · S/N 46-22067 N886ALHogue James B · Spencer, TNBuilt 1986 · S/N 4608037 N8888X82 Saratoga LLC · Bryant, ARBuilt 1989 · S/N 4622078 N888CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 468408030 N888EFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N 468608002

Back to AD 99-15-04 R1