Registered aircraft · 81,733

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

N3942MKraft Duane J · Timber Lake, SDBuilt 1947 · S/N 12-2593 N3942NFlying Services Inc · Wilmington, DEBuilt 1968 · S/N 680007 N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042 N3942TAuburn Valley LLC · Farmington, MNBuilt 1967 · S/N 28R-30285 N3942WLarkin Jason · Zeeland, MIBuilt 1967 · S/N 32-931 N3942ZHigh Exposure Inc · Wilmington, DEBuilt 1962 · S/N 18-7867 N3943Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1984 · S/N 17276186 N3943WCox Aviation LLC · Debord, KYBuilt 1967 · S/N 32-892 N3943XSuberg Valerie G · Windsor, CABuilt 1975 · S/N 28R-7535362 N3944FHenley Johnny · Trenton, NCBuilt 1976 · S/N 28-7615432 N3944KPeiker Laramie · Revillo, SDBuilt 1967 · S/N 28-23819 N3944MHebert Troxell S · Delta Jct, AKBuilt 1947 · S/N 12-2834 N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044 N3944SAlpha Romeo LLC · Wray, COBuilt 1990 · S/N 728 N3944WCatlin Flying Service LLC · Twisp, WABuilt 1967 · S/N 32-932 N3944XClark Nicholas J · Wilmington, DEBuilt 1975 · S/N 28R-7535363 N3944ZTasch Kenneth O · Chilton, WIBuilt 1962 · S/N 18-7801 N39456Lorber Robert M · East Brunswick, NJBuilt 1978 · S/N 28-7816660 N39457Pro-Aire Inc · Chisago City, MNBuilt 1978 · S/N 28R-7837297 N39459Hubert L Hooks Jones Chpt Of Tuskegee Airmen Inc · Denver, COBuilt 1978 · S/N 32R-7885219 N3945FBrougnton Eric S · Catlettsburg, KYBuilt 1976 · S/N 28-7690463 N3945KFisher Knute A · Kensington, CABuilt 1967 · S/N 28-23821 N3945PLiedtka Thomas M · Stevensville, MTBuilt 1956 · S/N 22-3620 N3945RJpx Aero Club Corp · East Hampton, NYBuilt 1970 · S/N 28-5854 N3945TElsinger Vincent R · Pierre, SDS/N 28R30288 N3945WSouth Bay Aviation Inc · Torrance, CAS/N 32-894 N3945ZKramer Thomas K Trustee · Anchorage, AKS/N 18-7802 N3946TPotter Allen W · Clinton Corners, NYBuilt 1967 · S/N 28R-30289 N39472Moore Tucker S · Keswick, VABuilt 1978 · S/N 28-7816662 N39474Hartwig Aircraft Fuel Cell Repair Inc · St AndrewsBuilt 1966 · S/N MB-23 N39478Jacies Wings LLC · Port Isabel, TXBuilt 1978 · S/N 32R-7885221 N39479Pgd Flyers LLC · Newark, DES/N 32R-7885222 N3947PGilger Douglas D II · Boyes, MTBuilt 1956 · S/N 22-3622 N3947ZVan Winkle James L · Wood Lake, NEBuilt 1962 · S/N 18-7805 N3948KMcilroy William E · Dyer, INBuilt 1967 · S/N 28-23824 N3948PMoore Roger D · Lubbock, TXBuilt 1956 · S/N 22-3623 N3948QCitabria Inc · Auburn, CABuilt 1971 · S/N 17260048 N3948TSchmidt Stephen M · Tipp City, OHS/N 28R-30291 N3948ZLiedtka Mark T · Stevensville, MTBuilt 1962 · S/N 18-7806 N3949Sliger Thomas Edward · Turlock, CABuilt 1971 · S/N SSBI N39496Texter John F · Saint Ignace, MIBuilt 1978 · S/N 28-7890536 N3949PGriggs Luz V · Goddard, KSBuilt 1956 · S/N 22-3626 N3949QTuschen James E · Rockford, ILBuilt 1971 · S/N 17260049 N3949THathaway Devon Scott · Buna, TXS/N 28R-30292 N3949XBlue Ridge Flyers · Leesburg, VABuilt 1975 · S/N 28R-7535365 N3949ZBarrickman William A · Anchorage, AKBuilt 1962 · S/N 18-7807 N394AAFlying Cnw LLC · Missoula, MTBuilt 2007 · S/N 2394 N394ACSmith Daniel A · Norton, MABuilt 1977 · S/N 1087 N394CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13103 N394CVBas Part Sales LLC · Greeley, COBuilt 2016 · S/N 18282437

Back to AD 81-18-04 R2