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.

N7342ANewberry Ernest B Jr · Crawfordville, FLBuilt 1957 · S/N 29442 N7342TKeyes George E Jr · Moab, UTBuilt 1959 · S/N 46942 N73433Salvation Neighborhood Development Corp · Riverside, CAS/N 17267457 N73434Monette Verne G · Anchorage, AKBuilt 1976 · S/N 17267458 N73435Air America Spares LLC · Daytona Beach, FLBuilt 1976 · S/N 17267459 N73439Umo Flight School LLC · Mount Olive, NCBuilt 1976 · S/N 17267462 N73441Stein Aporn U · Pepeekeo, HIBuilt 1976 · S/N 17267464 N73450Penn Yan Flying Club Inc · Penn Yan, NYBuilt 1976 · S/N 17267468 N73451Airward Inc · Columbia, CABuilt 1976 · S/N 17267469 N73452Hodges Jonathan D · Port Orchard, WABuilt 1976 · S/N 17267470 N73453Mfa LLC · Mount Pleasant, SCBuilt 1976 · S/N 17267471 N73454Yr-Aircraft Leasing LLC · Soldotna, AKBuilt 1976 · S/N 17267472 N73455101 Flight LLC · Waterford, MIBuilt 1976 · S/N 17267473 N73456K E F Enterprises · Plymouth, MABuilt 1976 · S/N 17267474 N73457Bmg Aviation Inc · Bloomington, INBuilt 1976 · S/N 17267475 N73459Stowers Joshua S · Niceville, FLBuilt 1976 · S/N 17267477 N7345GJacks Air Service Inc · Greenville, MEBuilt 1970 · S/N 17259045 N73461Monk Crafton L · Saraland, ALBuilt 1976 · S/N 17267478 N73462Farkas Dan · Wyoming, MIBuilt 1976 · S/N 17267479 N73464Knight Kevin J · Fort Wayne, INBuilt 1976 · S/N 17267481 N73468Tnt Airworks LLC · Hibbing, MNBuilt 1976 · S/N 17267484 N7346GBentley Darrell Howard · Powell, TNBuilt 1970 · S/N 17259046 N7346THalford Richard W · Eagle River, AKBuilt 1959 · S/N 46946 N73472Lajova LLC · Amarillo, TXBuilt 1976 · S/N 17267488 N73473Lauro Michael J · Kailua Kona, HIBuilt 1976 · S/N 17267489 N73477Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267493 N7347ATalkeetna Build A Plane Inc · Talkeetna, AKS/N 29447 N7347GN7347g LLC · Miami, FLBuilt 1970 · S/N 17259047 N73481N73481 LLC · Eaton, COBuilt 1976 · S/N 17267497 N73486Begley Edward · Glasgow, KYBuilt 1976 · S/N 17267501 N73487Spiess Michael Trustee · Montague, CABuilt 1976 · S/N 17267502 N73489Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1976 · S/N 17267503 N7348GHardy James H · Albany, NYBuilt 1970 · S/N 17259048 N73496Heartland Aviation Inc · Alliance, NEBuilt 1976 · S/N 17267506 N7349814a Flying Club Inc · Mooresville, NCBuilt 1976 · S/N 17267508 N7349ANorwood Brian B · Conway, ARBuilt 1956 · S/N 29449 N7349TOsipov Vladimir A · Charlotte, NCBuilt 1959 · S/N 46949 N734ACRich Lucas Aircraft Sales LLC · Lincoln Park, NJS/N 17268694 N734AEFlight Club 502 Inc · Louisville, KYBuilt 1977 · S/N 17268696 N734AHAnderson Zachary Q · Rudyard, MTBuilt 1977 · S/N 17268699 N734AMGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1977 · S/N 17268703 N734AQBarrans Daniel L · Glenmoore, PABuilt 1977 · S/N 17268705 N734ASStory Larry W · Double Oak, TXBuilt 1977 · S/N 17268707 N734AULeading Edge Aviation Inc · Doylestown, PABuilt 1977 · S/N 17268709 N734AXPenel Aviation Corp · Baldwin, NYBuilt 1977 · S/N 17268712 N734AYRico Aviation Services Inc · Miami, FLBuilt 1977 · S/N 17268713 N734BBLeading Edge Flight Academy LLC · Bend, ORBuilt 1977 · S/N 17268716 N734BFMortensen Jonathan J · Grovetown, GABuilt 1977 · S/N 17268720 N734BGVancina Simon J · New Lenox, ILBuilt 1977 · S/N 17268721 N734BHMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17268722

Back to AD 90-06-03 R1