Registered aircraft · 47,133

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

N478TFoster Theresa A · Scurry, TXBuilt 1964 · S/N D-7649 N4790BKringle Wendell K · Barron, WIBuilt 1955 · S/N 31688 N4790DGlobal Navigator LLC · Anacortes, WAS/N 34890 N4790FKise Scott T · Circle Pines, MNBuilt 1967 · S/N P206-0390 N4790ZBem Holdings LLC · Dover, DEBuilt 1974 · S/N 20700240 N47912Maxey Russell J · Midland, TXFirst renewal noticeS/N 28R-7803037 N47915Lewis Mechanical Inc · Wasilla, AKBuilt 1977 · S/N 34-7870014 N4791CSs Aviation Holdings LLC · Springdale, ARBuilt 2018 · S/N 1725 N4791DBoan Randall P · Milton, IABuilt 1958 · S/N 34891 N4791FPfp Aviators LLC · South Salt Lake, UTBuilt 1967 · S/N P206-0391 N4791UAerialtraders LLC · Fort Myers, FLBuilt 1979 · S/N U20605104 N4792UWegman Atlas George · Ghent, NYBuilt 1964 · S/N 18051492 N4794FGet Out Aviation LLC · Palmer, AKBuilt 1967 · S/N P206-0394 N4794MSky Inc · Council Bluffs, IABuilt 1978 · S/N TC-2142 N4795CPrecision Design Inc · Wilmington, DEBuilt 1979 · S/N 21063629 N4795DStemprok Roman · Corsicana, TXBuilt 1958 · S/N 34895 N4795FClark Joseph D · Kilgore, TXBuilt 1967 · S/N P206-0395 N4795QHinkle Airspray Inc · Cavalier, NDBuilt 1976 · S/N 18802534T N4795UParker Omalley Corp · Chatham, NYBuilt 1965 · S/N 18051495 N4796BHough Kenneth R · New Gloucester, MEBuilt 1955 · S/N 31694 N4796CHubbard Mark A · Wilmington, DEBuilt 1956 · S/N 23309 N4796GFranconia Soaring Association · Franconia, NHBuilt 1956 · S/N 23311 N4796K96k LLC · Cave Creek, AZBuilt 1979 · S/N P21000323 N4796MN4796m LLC · Norridge, ILBuilt 1978 · S/N D-10133 N4796NCessna N4796n LLC · Shreveport, LABuilt 1979 · S/N 18267374 N4796QNeufield Daniel · Brea, CABuilt 1964 · S/N CD-763 N4797MRegistration Pending · Satellite Beach, FLRegistration pendingBuilt 1978 · S/N TC-2146 N4797UPhilbrick Rodney C DBA · Bishop, CABuilt 1979 · S/N U20605108 N47987Mongo Corp · Santa Fe, NMBuilt 1977 · S/N 28R-7803052 N4798BRegistered aircraftBuilt 1955 · S/N 31696 N4798CKjv Aviation Inc · Brentwood, CAS/N 414-0012 N4798KAmerican Diversified Services LLC · Marietta, GABuilt 1979 · S/N P21000325 N4798PShepherd Mike · Amarillo, TXBuilt 1978 · S/N P21000112 N47990Williams Charles · Wadsworth, OHBuilt 1977 · S/N 34-7870024 N4799CFlying Horse LLC · Missoula, MTBuilt 1979 · S/N 21063632 N4799DDressen Donald L · Fruitland, IDBuilt 1958 · S/N 34899 N4799NLobb David C · Fort Myers, FLBuilt 1979 · S/N 18267377 N4799UChase 13 LLC · Wilmington, DEBuilt 1965 · S/N 18051499 N4799VDeparture Aviation Services LLC · Laurel Hill, NCS/N 30088 N479BAJml Aviation Inc · Jonesboro, ARBuilt 2014 · S/N E-4056 N479BCPetersen G5 LLC · Phoenix, AZBuilt 2015 · S/N 1073 N479BWKingsman Aviation LLC · Kenosha, WIBuilt 2024 · S/N 10317 N479CCRood Donald F · San Diego, CABuilt 1985 · S/N 25-1007 N479DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1821 N479HBDouble Bar Stationair LLC · Coeur D Alene, IDBuilt 1975 · S/N U20602923 N479JLLopez Jesus D · Garfield, ARS/N 18264124 N479JPHogancamp John M · Lebanon, TNBuilt 1976 · S/N E-801 N479KSHaaverson Enterprises Inc · Livermore, CABuilt 1993 · S/N E-2811 N479SVKollstedt Lance S · Tipp City, OHBuilt 1979 · S/N 79-30950 N479TWilson Chuck W · Mckinney, TXBuilt 1961 · S/N CD-425

Back to AD 2000-23-21