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.

N6986SKass Deborah J · Chandler, AZBuilt 1967 · S/N 15067686 N6987FGacesa Samuel M · Belton, TXBuilt 1966 · S/N 15063587 N6987SHubbard Broadcasting Inc · Saint Paul, MNBuilt 1967 · S/N 15067687 N6988FPaulson Allerton · Anoka, MNBuilt 1966 · S/N 15063588 N6990FWohlers Paul A · Calimesa, CABuilt 1966 · S/N 15063590 N6990YV Speed Aviation LLC · Reno, NVBuilt 1964 · S/N 21058490 N6991FMeyer George D · Paradise, CAS/N 15063591 N6991GMid South Aircraft Sales Inc · Glencoe, ALBuilt 1971 · S/N 15072491 N6992FJenkins Seth A · Charlotte, NCBuilt 1966 · S/N 15063592 N6992GMosch Edward C · Indialantic, FLBuilt 1971 · S/N 15072492 N6993FBordens Jacob R · Chatham, NJBuilt 1966 · S/N 15063593 N6994FHerring Jason D · Wasilla, AKS/N 15063594 N6995SNaylor Aviation LLC · Scotch Grove, IABuilt 1967 · S/N 15067695 N6997FSmith Roger D · Fayetteville, NCBuilt 1966 · S/N 15063597 N6998GAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 15072498 N6998SFowler John C · Scott Depot, WVBuilt 1967 · S/N 15067698 N69995Hillis Larry Gregory · Pickens, ARBuilt 1965 · S/N 18256289 N6999FHabibi Airlines LLC · San Juan, PRBuilt 1966 · S/N 15063599 N6999MAbonil Ty · Philadelphia, PABuilt 1964 · S/N 18255790 N699WWWallis Warren · Barstow, CABuilt 1969 · S/N 21059161 N69ACKendel Stephen George · Colbert, WABuilt 1969 · S/N 18260134 N69ELLewis Ethel M · Castro Valley, CABuilt 1962 · S/N 18254060 N69HGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1967 · S/N 15066045 N69HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1973 · S/N 15074403 N69HZU206 Ice LLC · Pompano Beach, FLS/N U206-1253 N69PRAero Inventory LLC · Monroe, GAS/N T210-0321 N69RMDicicca Yolanda L · BitontoBuilt 1977 · S/N 177RG1204 N69UTAux N69ut LLC · Portland, TXBuilt 1968 · S/N 18259464 N69WKirby Mitchell E · Gualala, CABuilt 1968 · S/N 18259436 N6ABCenterline Holdings Inc · Camden, DEBuilt 1969 · S/N 17258164 N6BEZephyr Enterprises Inc · Wilmington, DEBuilt 1977 · S/N 177RG1151 N6DNLowery William D · Geneva, FLBuilt 1963 · S/N 18255161 N6EKCjh Aviation LLC · New Bern, NCBuilt 1967 · S/N 15066827 N6FVAlexis Asplundh Studio LLC · Atlantic Beach, FLBuilt 1978 · S/N 177RG1365 N6HNTalbott Philip A · Galena, OHBuilt 1971 · S/N 172-60326 N6HQNazir Donna La Cruz · Boca Raton, FLBuilt 1966 · S/N U206-0581 N6MBSierra Whiskey Aircraft LLC · Oakland, CABuilt 1968 · S/N 17257279 N6MDCessna 6md LLC · Englewood, FLBuilt 1963 · S/N 2050315 N6MTSchwartz Amy A · Chandler, AZBuilt 1966 · S/N 15062848 N6QTM And K Industries LLC · Anchorage, AKBuilt 1964 · S/N 18255232 N6WADue North Aviation LLC · League City, TXBuilt 1971 · S/N 17701676 N7001GWhite Richard L · Pittsburgh, PABuilt 1973 · S/N 15074601 N7002FMcdonald Timothy M · Meredith, NHBuilt 1966 · S/N 15063602 N7003KSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 18259923 N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704 N7005FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063605 N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705 N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305 N7006QToney Edward L · Hampton, GABuilt 1971 · S/N 17260306 N7006SSpicer Greg · Portage, MIBuilt 1967 · S/N 15067706

Back to AD 72-03-03 R3