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.

N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053 N214MKoo C Carlos · Atherton, CABuilt 1985 · S/N P210-00863 N214MCCampbell Christian · Senoia, GAS/N D-6772 N214PJCabral Diogo Da Silva · New York, NYBuilt 1978 · S/N 18266080 N214QHassenger Management Strategies Inc · San Antonio, TXBuilt 1965 · S/N D-7932 N214RLlano Charles · Lakeland, FLBuilt 1977 · S/N 32R7780522 N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440 N214RCWhitcomb David · Morrisville, VTS/N D-7453 N214RDAardvark Aircraft LLC · Kalamazoo, MIBuilt 1964 · S/N 18255546 N214RJJones Larry V · Ocala, FLBuilt 1999 · S/N E3263 N214RSFlying Kw Co · Millsap, TXBuilt 1977 · S/N E-957 N214SANeagle Jason S · Elizabethtown, KYS/N 28-7415482 N214SHSiu Ena · Reno, NVBuilt 1963 · S/N E189 N214TJVector Aeromedical Services LLC · Smithfield, NCBuilt 1979 · S/N R18201275 N214WGriffeth John · Branson, MOBuilt 1969 · S/N 310Q0061 N214WKOutbound Group LLC · St Petersburg, FLBuilt 1969 · S/N 18260041 N21500Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 44-7995055 N21501Kelch Wendell · Bethel, OHBuilt 1973 · S/N 18261675 N21508Newton Christian B · Redondo Beach, CABuilt 1973 · S/N 18261678 N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031 N2150DRegistered aircraftBuilt 1953 · S/N D-3500 N2150ELeuer Nicholas J · Emmetsburg, IABuilt 1978 · S/N 17271170 N2150FShoreline Aviation Inc · Marshfield, MABuilt 1978 · S/N 28-7916186 N2150JKing Mark A · Nolensville, TNBuilt 1978 · S/N 28-7911064 N2150LB-58 Inc · Albany, GAS/N TH-781 N2150PWoodard Mark A · Hookstown, PABuilt 1956 · S/N 23-752 N2150RChalkley Benjamin G · North Liberty, IABuilt 1969 · S/N 28-5471 N2150TBecker Brian C · Fort Dodge, IABuilt 1971 · S/N 28-7105165 N2150YGoldstein Orpaz · Woodland Hills, CABuilt 1979 · S/N 28-7916360 N2150ZHilton Head Flyers LLC · Liberty, SCBuilt 1979 · S/N 28-7916382 N21514Davis Ryan Edward · Bonney Lake, WABuilt 1973 · S/N 18261681 N21515Airline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17263960 N21516Reinders Craig T · Hartland, WIBuilt 1973 · S/N 18261683 N21517Leighton Bryce L · Griswold, IABuilt 1974 · S/N 17263961 N21518Kilo Whiskey Aviation LLC · West Des Moines, IABuilt 1973 · S/N 18261685 N2151GLigons Michael J · Fredericktown, MOBuilt 1958 · S/N 51451 N2151RMclelland Ronald James · Taylorville, NCBuilt 1964 · S/N 18255351 N2151SSd Aviation LLC · Syracuse, KSBuilt 1975 · S/N 21061112 N2151ZClay Sibbitt LLC · Chandler, AZS/N 18051251 N21520Schroeder Benjamin · Mcgregor, TXBuilt 1973 · S/N 18261686 N21522Hove Paul · St Paul, MNBuilt 1978 · S/N 28-7916046 N21529Tbm Aviation LLC · Wellington, ALBuilt 1973 · S/N 18261692 N2152AWojtowicz Jacek A · Rhinebeck, NYBuilt 1978 · S/N 28-7916099 N2152RRobinson Aviation LLC · Wilmington, DEBuilt 1964 · S/N 18255352 N2152YSale Reported · Charlotte, NCSale reported, pending cancellationBuilt 1962 · S/N 17249652 N2152ZN2152z LLC · Middletown, DEBuilt 1979 · S/N 28-7916383 N21535Wilson Chad M · Mount Ida, ARBuilt 1974 · S/N 17263965 N21536Anb Aviation LLC · Bauxite, ARBuilt 1973 · S/N 18261698 N2153MBlocklin Bruce · Port Charlotte, FLBuilt 1977 · S/N 28R-7803110 N2153NEagle Air US Inc · Eau Claire, WIBuilt 1979 · S/N 32R-7987096

Back to AD 98-21-21 R1