Skip to content

Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N8838ZG2g Aviation LLC · Wray, COBuilt 1966 · S/N 17255488 N8839GRegistered aircraftBuilt 1966 · S/N 15062939 N8839USchuh Thomas M · Queen Creek, AZBuilt 1965 · S/N 17252750 N8839ZCole Samuel L M III · Kenai, AKBuilt 1966 · S/N 17255489 N8840SBlue Thunder Aviation LLC · Heath Springs, SCBuilt 1965 · S/N 15062140 N8840UHathor Aviation LLC · Johnstown, COBuilt 1965 · S/N 17252751 N8841GLinn Parker J · Brainerd, MNBuilt 1966 · S/N 15062941 N8841UNorcal Flight Center LLC · Lincoln, CABuilt 1966 · S/N 17252752 N8842GTiller Stanford C · Loup City, NEBuilt 1966 · S/N 15062942 N8842UHwa LLC · Charleston, SCBuilt 1965 · S/N 17252753 N8843GSanders Don · Mustang, OKBuilt 1966 · S/N 15062943 N8843UGullatt Jamey D · Mount Airy, NCBuilt 1965 · S/N 17252754 N8844GNorthside Logistics And Automotive Inc · Dardanelle, ARS/N 21059144 N8844ZTerry L Fowler LLC · Greenbrier, ARBuilt 1966 · S/N 17255494 N8845ZCartwright Adam C · Homestead, FLFirst renewal noticeS/N 17255495 N8846USmith Chad · Boulder City, NVBuilt 1965 · S/N 17252758 N8847GSabillon Luis H · Concord, CABuilt 1966 · S/N 15062947 N8847ZChristian Matthew T · Sebring, FLS/N 17255497 N8848GFlynn John P · Colebrook, NHBuilt 1967 · S/N 15066988 N8848ZMix Gary · Hoagland, INBuilt 1966 · S/N 17255498 N8849GSustarich Stephen M · Ketchikan, AKBuilt 1966 · S/N 15062949 N8849ZBagwell Aaron Edward · Mount Vernon, WABuilt 1966 · S/N 17255499 N8850GSchool Board Of Seminole County Florida · Sanford, FLS/N 15062950 N8850SFlyers Park Farm LLC · Newark, OHBuilt 1965 · S/N 15062150 N8851SChamseddine Ahmed A · Middletown, RIBuilt 1965 · S/N 15062151 N8852GAmis Jan E · Weeki Wachee, FLS/N 15062952 N8855GAldrich Curtiss R · Big Oak Flat, CABuilt 1966 · S/N 15062955 N8856GMorris Charles K · Miami, FLBuilt 1966 · S/N 15062956 N8856UKnutson Wayne R · Thompson, NDBuilt 1965 · S/N 17252770 N8857GUp And Away LLC · Seymour, TNBuilt 1967 · S/N 18258100 N8858SDenney Andrew I IV · Las Cruces, NMFirst renewal noticeBuilt 1965 · S/N 15062158 N8858UHolbrook Joel P · Delta Junction, AKBuilt 1965 · S/N 17252772 N8859GBaker Jacob J · Nags Head, NCBuilt 1966 · S/N 15062959 N885DERoberts James A · Hamburg, ARBuilt 1966 · S/N 17253885 N8860GBlack Spruce Aviation LLC · Hermon, MEBuilt 1966 · S/N 15062960 N8861GMiller Andy D · Marana, AZS/N 15062961 N8861SJump Brian · Watsonville, CAS/N 15062161 N8861UBlanchard Donald P Jr · Napoleonville, LABuilt 1965 · S/N 17252775 N8862SBarber Theodore C Trustee · Spanish Fork, UTS/N 15062162 N8862UChase Tim W · Kearney, MOBuilt 1965 · S/N 17252777 N8863UBoatman Robert G · Great Falls, MTBuilt 1965 · S/N 17252778 N8865GChiquiza Gomez Juan Camilo · Fort Pierce, FLS/N 15062965 N8865URegistration Pending · Parsons, KSRegistration pendingBuilt 1965 · S/N 17252780 N8866SZimmer Linda S · Hillsboro, ILBuilt 1965 · S/N 15062166 N8867GDavis Robert M · Liberal, KSBuilt 1966 · S/N 15062967 N8867SCooper-White Michael L · Orrtanna, PABuilt 1965 · S/N 15062167 N8867UHoffman Robert E · Blossvale, NYBuilt 1965 · S/N 17252782 N8868SMeriwether John N · Prairie Village, KSBuilt 1965 · S/N 15062168 N8868UMuller Robert J · River Falls, WIBuilt 1965 · S/N 17252784 N88717Copp Mathew J · Cumberland, MEBuilt 1969 · S/N 18260100

Back to AD 72-03-03 R3