Skip to content

Registered aircraft · 471

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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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:85-11-07-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.

N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078 N1028RGarner Donald G · Greeley, COBuilt 1980 · S/N P210-00401 N102KYPatriot Aviation LLC · Rostraver Township, PABuilt 1978 · S/N P21000093 N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366 N105DFWestwood Aero Inc · Porterville, CABuilt 1986 · S/N 21064999 N10TTHays John J Jr · Denton, TXBuilt 1978 · S/N P21000056 N113TTHaley John R · Tomball, TXBuilt 1979 · S/N P21000281 N117UMCn Aviation LLC · Gilbert, AZBuilt 1980 · S/N P21000530 N11JJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000511 N120BCHunyadi James W · Toledo, OHBuilt 1979 · S/N P21000404 N128EEAlgab Holdings LLC · Newark, DEBuilt 1978 · S/N P21000133 N12JGVosworx Aviation LLC · Morrison, COBuilt 1979 · S/N P21000365 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N1331MRegistered aircraftBuilt 1985 · S/N 21064903 N1400Salour Michael M · Carlsbad, CABuilt 1979 · S/N P210-00277 N152BTCoho Aviation LLC · Hillsboro, ORBuilt 1980 · S/N P21000486 N15CWN15cw LLC · Wilmington, DEBuilt 1983 · S/N P21000824 N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460 N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169 N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174 N177PEPicabo Livestock Co · Picabo, IDBuilt 1979 · S/N P21000334 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 N1978FLofty Pursuits LLC · Sacramento, CABuilt 1981 · S/N P21000711 N199TKDangel LLC · Hailey, IDBuilt 1979 · S/N P21000313 N19WBPacific Wildfire Enterprises LLC · Wilmington, DES/N P21000761 N209KSSchneider Kerry · Alpine, WYS/N P21000560 N210BESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N P210-00088 N210BGTurner Kenneth W · Arlington, WABuilt 1978 · S/N P21000025 N210BTGood Aviation LLC · Oshkosh, WIBuilt 1979 · S/N P21000555 N210CJettech Holdings LLC · Broomfield, COBuilt 1979 · S/N P21000218 N210CEMaas Aviation LLC · Pewaukee, WIBuilt 1980 · S/N P21000563 N210CPToeppen Chris P · Atherton, CABuilt 1979 · S/N P21000230 N210DLDaneco LLC · Houma, LABuilt 1978 · S/N P21000114 N210EFDespain Aviation LLC · Pendleton, ORBuilt 1979 · S/N P21000391 N210FMAero M Inc · Key West, FLBuilt 1979 · S/N P21000259 N210FVAvoyelles Rental Corp · Bunkie, LABuilt 1980 · S/N P21000572 N210GELeimbach Keith · Evergreen, COS/N P21000655 N210GUTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1978 · S/N P21000067 N210HFrey Farm LLC · Fallon, NVBuilt 1986 · S/N 21064951 N210HGBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000569 N210JPCsa Aviation LLC · Leonardtown, MDBuilt 1980 · S/N P21000630 N210JTToddair Inc · Jonesboro, GAS/N P21000589 N210KKKunkel David L · Boulder, COBuilt 1980 · S/N P210-00586 N210LAWright Gilbert G IV · San Antonio, TXBuilt 1985 · S/N P21000838 N210LFGolden West Flyers Inc · Turpin, OKBuilt 1978 · S/N P21000137 N210MFCollins Caryl A · Westcliffe, COBuilt 1978 · S/N P21000105 N210NLSsd2 LLC · Napa, CABuilt 1981 · S/N P21000674 N210PPPapaco LLC · Green Cove Springs, FLBuilt 1978 · S/N P21000100 N210RDPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000772 N210REValiair Lc Trustee · Casper, WYS/N P21000846

Back to AD 85-11-07 R1