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.

N734QSBerens James L · Benson, MNBuilt 1977 · S/N 17269036 N734QTWimberly Edgar J III · Fairfax, VABuilt 1977 · S/N 17269037 N734QVDuty Rollin A · Stratford, CAS/N 17269039 N734QZRegistration Pending · Centereach, NYRegistration pendingBuilt 1977 · S/N 17269043 N734RAAurora 17 Holdings LLC · Aurora, ORBuilt 1977 · S/N 17269044 N734RBAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 17269045 N734RDR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17269047 N734REInterspace Systems LLC · San Diego, CABuilt 1977 · S/N 17269048 N734RFWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17269049 N734RHFricks Philip B · Piedmont, SCBuilt 1977 · S/N 17269051 N734RJSica Jerry · Staten Island, NYBuilt 1977 · S/N 17269052 N734RKKosko Debra · Cambridge, OHBuilt 1977 · S/N 17269053 N734RPCf Images LLC · Fairfield, NJBuilt 1977 · S/N 17269057 N734RQFlywell Flying Club Inc · Roseville, MNBuilt 1977 · S/N 17269058 N734RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N 17269060 N734RTBehling Christopher · Rockford, ILBuilt 1977 · S/N 17269061 N734RVHonigstock Jay L · Arlington, VABuilt 1977 · S/N 17269063 N734RYKelm Edward C · Friday Harbor, WABuilt 1977 · S/N 17269066 N734SBLeatherman Lynn E II · Falling Waters, WVBuilt 1977 · S/N 17269069 N734SEJkg LLC · Murfreesboro, TNBuilt 1977 · S/N 17269071 N734SFRetsel Inc · Portsmouth, VABuilt 1977 · S/N 17269072 N734SJRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1977 · S/N 17269074 N734SMFive Mcds LLC · Jupiter, FLBuilt 1977 · S/N 17269077 N734SRJohnston Robert M · Bakersfield, CABuilt 1977 · S/N 17269081 N734STLeading Edge Aviation Inc · Bend, ORBuilt 1977 · S/N 17269083 N734SUBrown Melinda · Pax, WVBuilt 1977 · S/N 17269084 N734SWSierra Sky Aviation LLC · Kalispell, MTBuilt 1977 · S/N 17269086 N734SXMondo Beyondo Thrill Squadron · Pasadena, CABuilt 1977 · S/N 17269087 N734SYBeck Roger M Trustee · Goode, VAS/N 17269088 N734TJsta LLC · Sheridan, WYBuilt 1977 · S/N 17269138 N734TAIronbound Aviation Inc · Bellingham, MABuilt 1977 · S/N 17269090 N734TDDecolagem Aviation LLC · Woodbridge, VABuilt 1977 · S/N 17269093 N734TEWhite Jeffrey M · Carlsbad, CABuilt 1977 · S/N 17269094 N734TFHerman Grady B · Princeton, INBuilt 1977 · S/N 17269095 N734TLLopez Jose A · Heath, TXBuilt 1977 · S/N 17269100 N734TSMohle Darren H · Carlsbad, CAS/N 17269106 N734TUPradhan Anis · Torrance, CABuilt 1977 · S/N 17269108 N734TWFly Zone LLC · Wilmington, DEBuilt 1977 · S/N 17269110 N734TXKusnierz Theodore T · Gansevoort, NYBuilt 1977 · S/N 17269111 N734UAJorgensen Kathrine · Moscow, TNBuilt 1977 · S/N 17269114 N734UEJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1977 · S/N 17269118 N734UFAlen Sergio Raul · Davie, FLFirst renewal noticeS/N 17269119 N734UHSzymanski Collin A · Anchorage, AKS/N 17269121 N734UL734ul LLC · Blaine, MNBuilt 1977 · S/N 17269124 N734UMSweet Sunshine Produce Co LLC · Ocala, FLBuilt 1977 · S/N 17269125 N734UPLee Randall Ross · Houston, TXS/N 17269127 N734UQFuture Technologies Inc · Colonia, NJBuilt 1977 · S/N 17269128 N734URKastle Todd Trustee · Gilroy, CAS/N 17269129 N734USLowery Dwight W · Clayton, NCBuilt 1977 · S/N 17269130 N734UTBlue Sky Aviation LLC · Menominee, MIBuilt 1977 · S/N 17269131

Back to AD 80-25-07 R1