Skip to content

Registered aircraft · 25,369

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.

N1381WReed Michael S · Sweetwater, OKBuilt 1964 · S/N 2662 N13821Lexington Flying Club · Lexington, KYBuilt 1974 · S/N 17263015 N13830Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17263017 N13834Hastings Air LLC · Hastings, NEBuilt 1974 · S/N 17263018 N1383URegistered aircraftBuilt 1976 · S/N 17267054 N13849Durkee Robert J · Prineville, ORBuilt 1974 · S/N 17263021 N1384CRedwood Area Flyers LLC · Redwood Falls, MNBuilt 1977 · S/N 17702719 N1384WTz Aviation LLC · Enterprise, ALBuilt 1964 · S/N 2665 N13874Missionair LLC · Livingston, NYBuilt 1974 · S/N 17263026 N1387UCp Aircraft Leasing LLC · Danville, CABuilt 1976 · S/N 17267058 N13884Triple F Aviation LLC · Scott City, KSS/N 17263028 N13887Jkg LLC · Murfreesboro, TNBuilt 1974 · S/N 17263029 N13889Carver Brian J · Rockwell City, IABuilt 1974 · S/N 17263030 N1388UBeining Grant P · Fullerton, CABuilt 1976 · S/N 17267059 N1388WM30c 2666 LLC · Jenks, OKBuilt 1964 · S/N 2666 N13890Registration Pending · Commerce, GARegistration pendingBuilt 1974 · S/N 17263031 N13892Meyers Alexander C · Pittsburgh, PABuilt 1976 · S/N 17702475 N138ACZimmerman Gerald M · Savannah, GABuilt 1992 · S/N 677-92 N138FRAyotte Matthew A · South Haven, MIBuilt 1986 · S/N 17276545 N138GBBurgan Grover W · Jacksonville, FLBuilt 2005 · S/N 473-2005 N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442 N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994 N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673 N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N139ACDavis Mark A · Lubbock, TXBuilt 1992 · S/N 686-92 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N139BCTrombley Steven T · Worland, WYBuilt 2008 · S/N 506-2008 N139ERRick Aviation Inc · Newport News, VABuilt 1985 · S/N 17276532

Back to AD 80-25-07 R1