Skip to content

Registered aircraft · 137

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

N102TMJunior Fernando Sporleder · Sarasota, FLBuilt 1976 · S/N 31-7712015 N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023 N108ACKaplan Steven M · Key Largo, FLBuilt 1983 · S/N 31-8312014 N109FCUsda Forest Service Fepp · Tallahassee, FLBuilt 1980 · S/N 31-8012073 N10QBAsc Aviation LLC · Brandon, MSBuilt 1978 · S/N 31-7812065 N10YCToyz Aviation LLC · Worthington, KYBuilt 1979 · S/N 31-8012002 N1157SDig2fly LLC · Sandpoint, IDBuilt 1978 · S/N 317812093 N117JPSanborn Map Company Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612086 N11SBGrant Zachary J · Indianapolis, INBuilt 1976 · S/N 31-7612062 N120LPGramer Air IV LLC · Northville, MIBuilt 1977 · S/N 31-7812010 N123PTScheller Erik G Trustee · Gig Harbor, WAS/N 31-8112020 N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074 N133CTValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-7912118 N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046 N1470BBerger Leo · Nampa, IDS/N 31-7512061 N179RMRaven Air LLC · Coral Gables, FLBuilt 1979 · S/N 31-7912074 N189SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 31-7512045 N202DSValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 31-7912025 N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092 N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085 N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062 N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025 N24CKAir Travel Management LLC · Lemont Furnace, PABuilt 1975 · S/N 31-7512049 N250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLBuilt 1979 · S/N 31-7912045 N26GPGpi Geospatial Inc · Orlando, FLBuilt 1977 · S/N 31-7812001 N271ASSkattum LLC · Sioux Falls, SDBuilt 1976 · S/N 31-7612073 N27272Alpha United Air LLC · Wilmington, DEBuilt 1977 · S/N 31-7712063 N27282Sanborn Map Company Inc · Colorado Springs, COBuilt 1977 · S/N 31-7712071 N27447Laingkids LLC · Lewes, DEBuilt 1977 · S/N 31-7812022 N27449Airchoice LLC · Manchester, IABuilt 1977 · S/N 31-7812025 N27450Flying Oyster Investments II LLC · Apollo Beach, FLBuilt 1977 · S/N 31-7812027 N27481Sanborn Map Company Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812009 N27562Montcalm-Mcdonald LLC · Mansfield, LABuilt 1978 · S/N 31-7812050 N27647Aviation Department Inc · Avon Park, FLBuilt 1978 · S/N 31-7812084 N2765VWiebe Frank · Wellington, TXBuilt 1978 · S/N 31-7812048 N27693Sanborn Map Co Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812091 N27699Curnutt Daniel E · Tanner, ALBuilt 1978 · S/N 31-7812094 N27701Secure Aviation Inc · Tequesta, FLBuilt 1978 · S/N 31-7812096 N27835Aerowerks LLC · Louisville, KYBuilt 1978 · S/N 31-7912016 N284HBAviatiek LLC · Hudsonville, MIBuilt 1979 · S/N 31-7912099 N28DFGlobal Avionics LLC · Downey, CAS/N 31-7812121 N296CHTgl Partners LLC · Plant City, FLBuilt 1978 · S/N 31-7812062 N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006 N317HABauer Aviation LLC · Saint Germain, WIBuilt 1977 · S/N 31-7812043 N325AKInternational Air Services Inc Trustee · Carson City, NVS/N 31-8112016 N325BBCapital City Curb & Gutter LLC · Wake Forest, NCBuilt 1975 · S/N 31-7512021 N325CRDiaz Aviation LLC · South New Berlin, NYBuilt 1978 · S/N 31-7912001 N325FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 31-8212005 N325FJSale Reported · Hopkinsville, KYSale reportedBuilt 1977 · S/N 31-7812007 N325JAdonai International Ministries · Marine, ILBuilt 1976 · S/N 31-7712002

Back to AD 77-10-09