Skip to content

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.

N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268 N35216Dairy Air Inc · Wyoming, PABuilt 1976 · S/N 177RG1047 N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270 N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271 N3521KState Of North Carolina · Raleigh, NCBuilt 2002 · S/N 18280998 N3521MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816350 N3521PJet Jam LLC · Layton, UTBuilt 1955 · S/N 22-3275 N3521QCub Club Inc · Fort Myers, FLBuilt 2001 · S/N 172S8847 N3522Barnett Charles J · St Peter JerseyBuilt 1969 · S/N 30-1787 N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272 N35225Nguyen Ricky L · Honolulu, HIS/N 17702275 N35229Coneburripul Corp · Miami, FLBuilt 2001 · S/N 172S8837 N3522EKilgore William B · Eureka, CAS/N 17271572 N3522KAsap Realty LLC · Stroud, OKS/N 28-23608 N3522NRegistration Pending · Mandeville, LARegistration pendingBuilt 1967 · S/N 680082 N3522PBurling Daniel J DBA · Warsaw, NYBuilt 1955 · S/N 22-3276 N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661 N35230Christiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 17281017 N35231Dressler David S · Bend, ORBuilt 1976 · S/N 177RG1048 N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283 N3523MMichigan Seaplane LLC · White Lake, MIBuilt 1947 · S/N 12-2369 N3523PAdair Lawrence L Jr · Fountain Run, KYBuilt 1955 · S/N 22-3277 N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278 N3523RAviator Air Flight School LLC · Grand Prairie, TXBuilt 2001 · S/N 17281016 N3523WRamunni Andrew R · Medina, OHBuilt 1966 · S/N 32-408 N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286 N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288 N35246N35246 LLC · Stuart, FLBuilt 2001 · S/N 17281031 N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289 N35249Baker Douglas · Rye, NHBuilt 2001 · S/N 17281030 N3524AGrd Aviation LLC · Canyon Lake, TXBuilt 1953 · S/N 22-1796 N3524FRegistered aircraftBuilt 2001 · S/N 18280975 N3524LFlight Training Aircraft LLC · Wilmington, DEBuilt 2001 · S/N 172S8809 N3524MMontmorency Enterprises LLC · Atlanta, MIBuilt 1947 · S/N 12-2370 N3524NRickard Donald S · Florence, ALBuilt 1967 · S/N 680083 N3524PRichard Waldren LLC · Newberg, ORBuilt 1955 · S/N 22-3279 N3524QRegistered aircraftBuilt 1977 · S/N 28-7790462 N3524WDiaz Albert · Ocean Springs, MSS/N 32-409 N3524XKendrick Brian S · Kerrville, TXBuilt 1966 · S/N 670061 N3524ZRehmel Robert S · Liberty, INBuilt 1960 · S/N 22-7427 N35253Liu Kaiyu · Metairie, LABuilt 2001 · S/N 172S8831 N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293 N3525URandolph Macon Academy · Front Royal, VABuilt 2001 · S/N 172S8826 N3525WDavis Micihael K · Madison, GABuilt 1966 · S/N 32-411 N3525ZCollier Ronald O Trustee · Seymour, TNBuilt 1960 · S/N 22-7428 N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296 N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297 N35266Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 6190 N3526KCooke Canyon C · Marana, AZBuilt 1967 · S/N 28-23606 N3526NDace Joshua R · Rochester Hills, MIBuilt 1967 · S/N 680084

Back to AD 81-18-04 R2