Skip to content

Registered aircraft · 3,961

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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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:87-21-02-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.

N98747American Skyways Inc · Corning, NYBuilt 1976 · S/N 340A0065 N987MCTwa LLC · Weatherford, OKFirst renewal noticeBuilt 1977 · S/N 421C0439 N98834Guzman Franklin · Teaneck, NJBuilt 1976 · S/N 310R0603 N98842Dan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1976 · S/N 310R0609 N98869Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N 310R0625 N98892Bright Aviation LLC · Salt Lake City, UTBuilt 1977 · S/N 310R1204 N98899Air Z Flying Service Inc · Willoughby, OHBuilt 1976 · S/N 310R0642 N988DMHart Paul E · El Macero, CABuilt 1981 · S/N 340A1244 N98911Roettger Electric Co Inc · Evansville, INBuilt 1976 · S/N 310R0646 N9892084wc Inc · Lewes, DEBuilt 1976 · S/N 310R0647 N98943Watts John J · Murchison, TXBuilt 1977 · S/N 310R1243 N98974Tolson Michael A · Waleska, GABuilt 1976 · S/N 310R0671 N98980Hyder Plumbing Co Inc · Tryon, NCBuilt 1976 · S/N 310R0675 N989AAMouat Brian · Trent Woods, NCS/N 401A-0042 N98CEQueen Aviation LLC · Wilmington, DEBuilt 1978 · S/N 414A0066 N98DMSonrise Aviation LLC · Portland, INBuilt 1976 · S/N 310R0819 N98MMSrt Group Inc · Southaven, MSBuilt 1979 · S/N 340A0639 N98RCPegasus LLC · Farmington, NMBuilt 1973 · S/N 340-0187 N990JBMurphy George E · Robinson, ILBuilt 1977 · S/N 340A0370 N990PCCmm Enterprises LLC · Pharr, TXBuilt 1974 · S/N 414-0546 N9915FKeith William F · Bakersfield, CABuilt 1973 · S/N 310Q0719 N991AAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0317 N991EMNorth American Aviation LLC · Pass Christian, MSS/N 414-0948 N991GJIsland Charter LLC · Wilmington, DEBuilt 1979 · S/N 310R1803 N9920FSmith Glenn A · Horseshoe Bay, TXBuilt 1972 · S/N 310Q0483 N9921FReap Aviation LLC · Radford, VABuilt 1972 · S/N 310Q0484 N9923FLlm Technology LLC · Austin, TXBuilt 1973 · S/N 310Q0722 N9924FMontemayor Rodrigo · Mcallen, TXBuilt 1973 · S/N 310Q0723 N9928FWatermaster Irrigation Supply Inc · Lubbock, TXBuilt 1972 · S/N 340-0165 N992POdom Johnny C · Fredericksburg, TXBuilt 1977 · S/N 310R1210 N9940FHarvey Air LLC · Arlington, TNBuilt 1972 · S/N 340-0173 N994MZMahz Air LLC · Laredo, TXBuilt 1985 · S/N 421C1803 N9953CEjj Group Inc · New York, NYBuilt 1983 · S/N T30300241 N995GPQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 310R1328 N997JDAviation.One Business Holdings LLC · Mesa, AZBuilt 1984 · S/N 414A1004 N997TAAir Flight Inc · Fort Lauderdale, FLFirst renewal noticeBuilt 1980 · S/N 402C-0231 N998JA2 Doods LLC · Lakewood Ranch, FLBuilt 1979 · S/N 310R0938 N999BSSale Reported · Moss Beach, CASale reported, pending cancellationBuilt 1968 · S/N 320F-0041 N999DCTbm Avenger Inc · Peru, ILBuilt 1976 · S/N 340A0035 N999DMJr605dc LLC · Amarillo, TXBuilt 1980 · S/N 421C0869 N999EBEngines Inc · Jonesboro, ARBuilt 1979 · S/N 340A0951 N999EUValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 414A-0233 N999HDEscobar Juan Carlos · Juncos, PRS/N 310Q0463 N999HQProclaim Aviation Ministries · Worthington, MNBuilt 1976 · S/N 310R0720 N999JLFlying Swan LLC · Ashland, NHBuilt 1973 · S/N 414-0479 N999RKTcg Aviation LLC · Pelham, ALBuilt 1974 · S/N 414-0610 N999WLLatshaw Training Group Inc · Vero Beach, FLS/N 421C0320 N99HJMf Property Management LLC · Hattiesburg, MSBuilt 1978 · S/N 414A0041 N99VK421 Golden Eagle LLC · Cheyenne, WYBuilt 1969 · S/N 421A0091 N9AMHangen Mark C · Flagstaff, AZBuilt 1969 · S/N 310P0196

Back to AD 87-21-02 R1