Skip to content

Registered aircraft · 25,368

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N92ELTrue Course Aviation LLC · Flower Mound, TXBuilt 1992 · S/N 24-3273 N92FRGliem Robert E Jr · Eddystone, PABuilt 1979 · S/N 17273140 N92GKRatchford Herman Jr · Bessemer City, NCBuilt 2025 · S/N 1222-2025 N92KBRaphael Dennis C · Colorado Springs, COBuilt 1992 · S/N 662-92 N92MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 17266052 N92MSCil N92ms LLC · Mcallen, TXS/N P21000689 N92RZSale Reported · Gold Canyon, AZSale reportedBuilt 1979 · S/N R18201313 N92SGStraight And Level LLC · Woodbine, MDBuilt 2014 · S/N 1149-2014 N93002Lcc North LLC · Freehold, NJBuilt 1981 · S/N 15285374 N9300VRyan C Hanneken · Hollywood, MDS/N 690084 N9301BGimli Son LLC · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0786 N9301ERyan Aircraft Holding LLC · Orlando, FLBuilt 1979 · S/N 17272216 N9301MPivac Jorge I · Chandler, AZS/N 1234 N9301VHack Christopher J · Highland Lakes, NJBuilt 1969 · S/N 690086 N9303MPierotti Robert Paul · Bowie, TXBuilt 1966 · S/N 1236 N9304HWischmeyer Matthew R · Hopewell Junction, NYBuilt 1975 · S/N 17266078 N9304MSweeney William B · Leesville, LABuilt 1966 · S/N 1237 N9304TPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 38-78A0013 N9305MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 1238 N9306HAnycomm Corp · Gold River, CABuilt 1975 · S/N 17266079 N9306MV1 Consulting Co · Crestwood, KYBuilt 1966 · S/N 1239 N9306VWilliams Steven M · Redwood, NYS/N 690069 N93078Black Cat Aviation LLC · Centennial, COBuilt 1981 · S/N 15285391 N9307DAviatzone LLC · Fort Lauderdale, FLBuilt 1982 · S/N 172RG1114 N9307MCassling Edward F · Newark Valley, NYBuilt 1966 · S/N 1240 N9307YRader Drew · Avon, COBuilt 1981 · S/N 21064467 N93082Schweiger Nathaniel A · Richland, WABuilt 1981 · S/N 15285394 N93085Hoffsette Dianna L Trustee · Saint Catharine, MOBuilt 1981 · S/N 15285396 N9308MDegraaf Derrick B · Manteca, CABuilt 1966 · S/N 1241 N9308VDapaah Seth O · Upper Marlboro, MDBuilt 1969 · S/N 690086 N93096Ngumba Andrew N · Long Beach, CABuilt 1981 · S/N 15285399 N9309YYecny Alan K · San Luis Obispo, CABuilt 1981 · S/N 21064469 N9310DRegistered aircraftBuilt 1982 · S/N 172RG1116 N9310HLilienthal Donald W · Cyrus, MNBuilt 1975 · S/N 17266080 N93116Wichita Area Technical College · Wichita, KSBuilt 1981 · S/N 15285405 N9311MShamshir LLC · Lake Havasu City, AZBuilt 1966 · S/N 1244 N9311VRegistration Pending · Queen Creek, AZRegistration pendingBuilt 1969 · S/N 690090 N93124Pavco Inc · Gig Harbor, WABuilt 1981 · S/N 15285409 N93127Dunn W Eric · Lake Wylie, SCBuilt 1981 · S/N 15285411 N9312MSteinman Marc J · Frankfort, ILBuilt 1966 · S/N 1245 N9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 172RG0788 N9313DSteneker Siardus L · Vashon, WABuilt 1983 · S/N 172RG1117 N9313GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801450 N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081 N9313M9313 Mike Inc · New Smyrna Beach, FLBuilt 1966 · S/N 1246 N93142Geoffrion Curt J · Kenai, AKS/N 15285415 N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220 N9314HAzevedo Bradley J · San Francisco, CABuilt 1981 · S/N 18267931 N9314TGriffith Stephen P · Merritt Island, FLBuilt 1978 · S/N 38-78A0024 N93154H & H Aviation Enterprises LLC · Fairfield, OHBuilt 1981 · S/N 15285422

Back to AD 80-25-07 R1