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.

N800KWVenture Air Solutions Inc · Opa Locka, FLBuilt 1976 · S/N 402B1063 N800MGSnell Marion Lea · Ackerly, TXBuilt 1974 · S/N 310Q0937 N800SMTofanzadeh Abdolreza · Chula Vista, CABuilt 1972 · S/N 421B-0275 N8013MBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 310I0013 N8014MCaldwell Machine & Gear Inc · Mount Pleasant, TXBuilt 1964 · S/N 310I0014 N8015MGill Conrad D · Mounds, OKBuilt 1964 · S/N 310I0015 N8030MInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 310I0030 N8034QGoins Plastic Source Inc · Texarkana, ARBuilt 1973 · S/N 310Q0691 N8036MObreiter Robert W Jr · Simi Valley, CABuilt 1964 · S/N 310I0036 N8047MVertigo Aviation Inc · Lighthouse Point, FLBuilt 1964 · S/N 310I0047 N8047QAir Boys Inc · Hayward, WIBuilt 1970 · S/N 421B0047 N8050MPrice Earl · Audubon, PABuilt 1964 · S/N 310I0050 N8055MHuffman Jacob M III · Burleson, TXBuilt 1964 · S/N 310I0055 N8056MHooper David M Trustee · South Jordan, UTBuilt 1964 · S/N 310I0056 N8060MBata Michael R · Port Orange, FLS/N 310I0060 N8071MLand Sea And Air Inc · North Mankato, MNS/N 310I0071 N8072MHigh Speed Flight Associates · Nickerson, KSS/N 310I0072 N8073MRussell David L · Wasilla, AKS/N 310I0073 N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300 N8081MHawk Hangars Corporation LLC · Jenks, OKS/N 310I0081 N8083MUpshaw John L Jr · Claude, TXBuilt 1964 · S/N 310I0083 N8086MCaudell Michael A · Cleveland, GABuilt 1964 · S/N 310I0086 N8091QKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 402B0369 N8093QRobey Sean C · Camden, NCBuilt 1973 · S/N 421B0544 N8097MNovember Sierra Aviation LLC · Oneill, NES/N 310I0097 N80DWSale Reported · Lumberton, NCSale reported, pending cancellationBuilt 1958 · S/N 35782 N80KRegistration Pending · Sparks, NVRegistration pendingBuilt 1963 · S/N 310H0098 N80RSRoberson Mark E · Milton, FLBuilt 1975 · S/N 421B0895 N8103MCunningham Michael J · Great Falls, MTBuilt 1964 · S/N 310I0103 N8109MRegistered aircraftBuilt 1964 · S/N 310I0109 N810SLidman Kirby · Ames, IABuilt 1964 · S/N 320B0062 N8112MFiedler Allen J · Imperial, PABuilt 1964 · S/N 310I0112 N8113MLansing Community College · Mason, MIBuilt 1964 · S/N 310I0113 N8116MJacobs Levon Jr · Oak Hill, FLBuilt 1964 · S/N 310I0116 N8118MRider Scott M · Beaverton, ORBuilt 1964 · S/N 310I0118 N811MCSatterthwaite Ryan W · Lynn Haven, FLS/N 35272 N8122MNo Slack Flyers LLC · Klamath Falls, ORFirst renewal noticeBuilt 1964 · S/N 310I0122 N8125FMaglaughlin Ronald D · Udall, KSFirst renewal noticeS/N 402-0231 N8133QFinnan-Johnson Flying Club LLC · Woodinville, WABuilt 1972 · S/N 310Q0626 N8136ZUniversity Of Alaska Anchorage · Anchorage, AKS/N 31010004 N8139MAcme Racing LLC · Overland Park, KSBuilt 1964 · S/N 310I0139 N8141MTerry Jan Chester · Beverly Hills, FLBuilt 1964 · S/N 310I0141 N8147MDe La Rosa Sergio · Nogales, AZBuilt 1964 · S/N 310I0147 N8166MMagafly LLC · Bay City, MIS/N 310I0166 N8166QE S P Aviation LLC · Wilmington, DEBuilt 1972 · S/N 310Q0633 N8167MFrick Richard W · Sidell, ILBuilt 1964 · S/N 310I0167 N8168MWilliams Charles S · Kingwood, TXBuilt 1964 · S/N 310I0168 N816LHL Howard Construction Inc · Abernathy, TXS/N 421B0565 N8177MSouthern Sky Enterprises LLC · Lafayette, LABuilt 1964 · S/N 310I0177 N8178MAcevedo Xochil · San Antonio, TXS/N 310I0178

Back to AD 72-14-08 R1