Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N734NFSeven4zulu LLC · San Diego, CAS/N 17268978 N734NJFlyright Aviation Inc · North Las Vegas, NVBuilt 1977 · S/N 17268981 N734NKBlue Sky Aviation LLC · El Cajon, CABuilt 1977 · S/N 17268982 N734NMTin Cup Investments Inc · Panama City Beach, FLS/N 17268984 N734NRVintage Aircraft Group · Albion, NYBuilt 1977 · S/N 17268988 N734NSLacey Thomas E · Tarpon Springs, FLBuilt 1977 · S/N 17268989 N734NVWiesehan Scott · Canby, ORS/N 17268992 N734NYAfton Flying Club LLC · Thayne, WYBuilt 1977 · S/N 17268995 N734PBFinney Brad A · Bayside, CABuilt 1977 · S/N 17268997 N734PCBarr Michael J · Colorado Springs, COFirst renewal noticeS/N 17268998 N734PDS Squared Aircraft LLC · Lewes, DEBuilt 1977 · S/N 17268999 N734PECupp Aviation LLC · Marceline, MOBuilt 1977 · S/N 17269000 N734PFWhiskey Sierra Enterprises LLC · Amarillo, TXBuilt 1977 · S/N 17269001 N734PGAmerican Aircraft Brokers LLC · Aurora, ORBuilt 1977 · S/N 17269002 N734PHTiger Bait Aviation LLC · Gulfport, MSBuilt 1977 · S/N 17269003 N734PKPurdue Aviation LLC · West Lafayette, INBuilt 1977 · S/N 17269005 N734PNDalton Paige B · Winston Salem, NCBuilt 1977 · S/N 17269008 N734PSUmo Flight School LLC · Mount Olive, NCBuilt 1977 · S/N 17269012 N734PUArispe Aviation LLC · Mckinney, TXBuilt 1977 · S/N 17269014 N734PVJamison Robert M · Mayfield Hts, OHBuilt 1977 · S/N 17269015 N734PWKempton Larry G Jr · Grand Junction, COS/N 17269016 N734QFPower Play Leasing LLC · Stuart, FLBuilt 1977 · S/N 17269025 N734QH3 Generations LLC · Bar Harbor, MES/N 17269027 N734QMAlaska Sky School LLC · Anchorage, AKBuilt 1977 · S/N 17269031 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

Back to AD 90-06-03 R1