Skip to content

Registered aircraft · 17,027

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.

N32CHHeckler Gary C · Carefree, AZBuilt 1966 · S/N 18257332 N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454 N3300JIngram Jay Wallis · El Paso, TXBuilt 1966 · S/N 15066000 N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300 N3301RJuliet Zulu Holdings LLC · Dover, DEBuilt 1967 · S/N 18258601 N3302JWignot Andrew R · Oceanside, CABuilt 1966 · S/N 15066002 N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302 N3303JWilliams Charles S · Pearland, TXBuilt 1967 · S/N 15066003 N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303 N3304FStephan Pamela K · Anchorage, AKBuilt 1966 · S/N 18257304 N3305RLivingston Sonja L · Redding, CABuilt 1967 · S/N 18258605 N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305 N3306JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15066006 N3306UMartin Paul R Jr · Greensboro, GABuilt 1963 · S/N 18254706 N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306 N3307RPhan Tam M · Charlotte, NCBuilt 1967 · S/N 18258607 N3307UPatronyk Gregory M · Santa Barbara, CABuilt 1963 · S/N 18254707 N3308FBravo Hotel LLC · Lewes, DES/N 18257308 N3308RLocatelli Gabriel G · North Bend, ORBuilt 1967 · S/N 18258608 N3309JMomentum Foundation · Tullahoma, TNS/N 15066009 N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109 N3309YRuschak Donald A · Charleroi, PABuilt 1962 · S/N 18254309 N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158 N3310RSeitz Martin V · Brookfield, WIBuilt 1967 · S/N 18258610 N3310TFly448 LLC · Wausau, WIBuilt 1968 · S/N 17700045 N3310YRegistration Pending · Fayetteville, ARRegistration pendingS/N 18254310 N3311RView From Above Inc · Columbia, CABuilt 1967 · S/N 18258611 N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N3311UBeck Gary · Albuquerque, NMBuilt 1963 · S/N 18254711 N3311YChavez Rafael J · Santa Fe, NMBuilt 1962 · S/N 18254311 N3312FWill Robert J · Fall City, WABuilt 1966 · S/N 18257312 N3312JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15066012 N3312RParish Mark · Earth, TXBuilt 1967 · S/N 18258612 N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112 N3312URoberts Air Inc · Goodwin, ARBuilt 1963 · S/N 18254712 N3313JEsckelson Eric S · Cass City, MIS/N 15066013 N3313ULayton Robert H · Seminole, TXBuilt 1963 · S/N 18254713 N3313YCosta Flying Service Inc · Painted Post, NYS/N 18254313 N3314YSimas Filomeno M · Grover Beach, CABuilt 1962 · S/N 18254314 N3315FSabbe Bros Flying Service Inc · Maddock, NDFirst renewal noticeBuilt 1966 · S/N 18257315 N3315JFlying Shiba Inus LLC · Dallas, TXS/N 15066015 N3315RTriple X Construction Inc · Camp Verde, AZBuilt 1967 · S/N 18258615 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N3316JChipollini Jorge · Springdale, ARBuilt 1966 · S/N 15066016 N3316RBranstetter Jack · Ponca City, OKS/N 18258616 N3317FPeniston Mandy J · Chillicothe, MOBuilt 1966 · S/N 18257317 N3317RBanti Gustavo · Marco Island, FLBuilt 1967 · S/N 18258617 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N3317USierra Aviation LLC · Fond Du Lac, WIBuilt 1963 · S/N 18254717

Back to AD 72-03-03 R3