Skip to content

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N2027XArchuleta Tommy L Jr · Bermuda Dunes, CABuilt 1965 · S/N 18256127 N2027YBarnhouse Vicki L · Hurricane, WVBuilt 1962 · S/N 17249527 N20282Fowler Jeffery T · Hopewell, OHBuilt 1972 · S/N 17261156 N20283Positive Attitude Ia Lc · Gaithersburg, MDBuilt 1972 · S/N 17261157 N20286Shenvair LLC · Bridgewater, VABuilt 1972 · S/N 17261159 N20289Whiskey 36 LLC · Norfolk, VABuilt 1972 · S/N 17261162 N2028AWallender Timothy J · Manhattan Beach, CABuilt 1969 · S/N D-9026 N2028PFerm Michael D · Fort Calhoun, NEBuilt 1978 · S/N D-10167 N2028RMurphy Kevin Adam · Douglas, GABuilt 1969 · S/N 28-5437 N2028SScherler Burl M · Sheridan Lake, COBuilt 1975 · S/N 21060996 N2028WN2028w LLC · Oakdale, CABuilt 1966 · S/N TE-87 N2028XWalker James H III · Anderson, SCBuilt 1965 · S/N 18256128 N20290Payne Larry D · Maryville, TNBuilt 1972 · S/N 17261163 N20291Shergalis William T · Lake Placid, FLBuilt 1972 · S/N 17261164 N20292Laflight LLC · Goldsboro, NCBuilt 1978 · S/N TH-966 N20295Adk Flying Club Inc · Ballston Spa, NYBuilt 1972 · S/N 17261168 N20298Hovey Patricia R Trustee · Auxvasse, MOBuilt 1972 · S/N 17261171 N20299Smiley LLC · Clovis, CABuilt 1972 · S/N 17261172 N2029CAnderson Rebecca L · Fort Myers, FLS/N TD-197 N2029DVictory Auto Sales LLC · Memphis, TNFirst renewal noticeBuilt 1978 · S/N D-10168 N2029GHendry Jeremiah D · Aurora, ILS/N 51329 N2029PTurnpoints LLC · Wilmington, DEBuilt 1978 · S/N E-1346 N2029RSoardro Ltd · Wilmington, DEBuilt 1964 · S/N 18255229 N2029SCanyon West LLC · Amarillo, TXFirst renewal noticeBuilt 1975 · S/N 21060997 N2029WWilliams Steve C · Elgin, SCBuilt 1966 · S/N CD-978 N2029YFox Matthew H · Stony Brook, NYBuilt 1962 · S/N 17249529 N202AMWalla Walla University · College Place, WABuilt 1975 · S/N 17266213 N202ASQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 287305465 N202BCTff Inc · Parma, MIBuilt 1957 · S/N D-5199 N202CBBrothers Aviation Va LLC · Manassas, VABuilt 1973 · S/N 28-7305360 N202CTIsrael Oscar M IV · Sinton, TXS/N R182-00060 N202DKarschney Rich · Pateros, WABuilt 1947 · S/N D-57 N202DCThornton Dana S · Edgartown, MAS/N 24-0013 N202DKAuto Key Masters And Locksmith LLC · Watts, OKBuilt 1978 · S/N TC2152 N202DSValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 31-7912025 N202EPSonnenberg Jerry · Sterling, COBuilt 1980 · S/N 18267673 N202FWeiherer Jeffrey Paul · Thousand Oaks, CABuilt 1957 · S/N 34011 N202GESt Amant Mark S · Diamond Bar, CABuilt 1964 · S/N 2896 N202JRiche Aviation LLC · Baton Rouge, LABuilt 1964 · S/N D-7418 N202JAAdams Toby R · Paris, TXBuilt 1963 · S/N 2570 N202KASkybrothers LLC · Scottsdale, AZBuilt 1974 · S/N 34-7450076 N202MAHatchett William Hal · Edisto Island, SCBuilt 1970 · S/N 28-26740 N202MDHay Pile Aviation LLC · Gilbert, AZBuilt 1966 · S/N TE-148 N202MGCoast To Coast LLC · Branson West, MOS/N 24-1630 N202NEJepsen William R Trustee · Enterprise, ORBuilt 1976 · S/N 17268104 N202PSc Infinities LLC · Dover, DEBuilt 1998 · S/N TH-1875 N202PCLowell Bret I · Aurora, COBuilt 1981 · S/N 24-1086 N202PMIrons Gregory B · Nixa, MOBuilt 1967 · S/N 670440 N202PYEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 17271126 N202SMyers Jon D · Montrose, COBuilt 1956 · S/N 32355

Back to AD 98-21-21 R1