Skip to content

Registered aircraft · 163

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:78-08-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-08-10') 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:78-08-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-08-10')
  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:78-08-10')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-08-10')
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 N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030 N133CTValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-7912118 N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935 N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046 N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903 N1470BBerger Leo · Nampa, IDS/N 31-7512061 N16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVBuilt 1970 · S/N 31-639 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 N212RAAbin Ricardo · Miami Lakes, FLBuilt 1977 · S/N 317712057 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 N250MDInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31-742 N262ASAerodata LLC · Ann Arbor, MIBuilt 1977 · S/N 31-7712102 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 N27712Juliet Lima Marketing Inc · West Palm Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 31-7812102 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 N28DVHood Geoffrey A · Gladstone, MOS/N 31-7912063

Back to AD 78-08-10