Skip to content

Registered aircraft · 1,578

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-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N175KBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 401B0206 N1760HReeve Howard E · Minot, NDBuilt 1959 · S/N 35860 N1766HOrlandi Properties LLC · Blairstown, NJBuilt 1959 · S/N 35866 N1777HFait Coleman B · Newport Beach, CABuilt 1959 · S/N 35877 N1783HRegistration Pending · Anchor Point, AKRegistration pendingBuilt 1959 · S/N 35883 N1797HRons Air Service Inc · Two Buttes, COS/N 35897 N17HLRiley Charles S · Littleton, COS/N 421B-0310 N17UAce Flight LLC · Houma, LABuilt 1964 · S/N 310I0093 N1811HLeggett Jason · Bogue Chitto, MSS/N 35911 N1816HKiever Robert P · Summerland Key, FLBuilt 1959 · S/N 35916 N1827HWard Austin · Kokomo, INBuilt 1959 · S/N 35927 N1831HKulp Clayton H · Wichita, KSBuilt 1959 · S/N 35931 N1837HYeagley Daun III · Moraine, OHBuilt 1959 · S/N 35937 N184PSStrama Aviation LLC · Ocala, FLBuilt 1965 · S/N 310J0111 N1852HI Fly Stl LLC · Saint Louis, MOBuilt 1959 · S/N 35952 N1856HVieman John D · Owensville, MOBuilt 1959 · S/N 35956 N1862TBradley Max T II · West Plains, MOBuilt 1959 · S/N 35962 N186THSandy Hook Aviation LLC · Sandy Hook, MSBuilt 1966 · S/N 310L-0029 N1873HBlue Canoe Aviation LLC · Chicago, ILBuilt 1952 · S/N 35973 N1879HRegan Robert C · Kent, WABuilt 1959 · S/N 35979 N187WWOsprey Aviation LLC · Riva, MDBuilt 1971 · S/N 310Q0252 N1886HGoodwin Joseph N · Grass Valley, CABuilt 1959 · S/N 35986 N189MWWilliamson Aviation Inc · Tullahoma, TNBuilt 1968 · S/N 310N-0003 N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144 N1919LSmith Sydney O · Lithonia, GAS/N 411-0157 N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229 N1925GEfi Technology Inc · Cave Creek, AZBuilt 1975 · S/N 421B0826 N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842 N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844 N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846 N1956Sturges George S Jr · Bakersfield, CABuilt 1956 · S/N 35337 N196RLunsford Joel T · Jasper, TXBuilt 1955 · S/N 35049 N19AFBegley Edward R · Glasgow, KYBuilt 1966 · S/N 310K0100 N19DBDcs Air LLC · Pulaski, WIBuilt 1972 · S/N 310Q0668 N19LFN19lf Corp · Oak Lawn, ILBuilt 1972 · S/N 310Q0622 N1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0236 N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580 N200LEAeromarine Holdings LLC · Waukesha, WIBuilt 1979 · S/N 310R1842 N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004 N202ZLojas Phillip · San Ysidro, CAS/N 411-0292 N208VBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 421B0866 N20MWStriebel David J · Dayton, OHBuilt 1975 · S/N 421B0918 N20NGTas Aviation Of Defiance Inc · Defiance, OHBuilt 1971 · S/N 310Q0276 N210FCBaked Industries Inc · Yuba City, CABuilt 1975 · S/N 421B0908 N21430Burns Preston · Spruce Pine, ALBuilt 1990 · S/N 310Q1073 N214DFGaylord Hangars LLC · Gaylord, MIBuilt 1973 · S/N 421B0461 N214WGriffeth John · Branson, MOBuilt 1969 · S/N 310Q0061 N215AMurphy Dan A · Two Harbors, MNBuilt 1954 · S/N 35013 N217BSRegistration Pending · Nogales, AZRegistration pendingBuilt 1963 · S/N 310H0034 N218USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 310Q0507

Back to AD 72-14-08 R1