Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N4331RConsolidated Aviation Services LLC · Seymour, TNBuilt 1974 · S/N 17263084 N4332COdom Douglas · Jay, FLBuilt 1978 · S/N 18803135T N4332RHolland Peter B · Uniontown, WABuilt 1974 · S/N 17263085 N4333LDover Amanda · Littleton, NCBuilt 1966 · S/N 17254402 N4333RReigle Aviation · Palmyra, PABuilt 1974 · S/N 17263086 N4334LOcuto Vincent Louis II · Homestead, FLS/N 17269555 N4334QDickey Alan J · Fort Wayne, INBuilt 1971 · S/N 17260234 N4334RAir Dakota Flite Inc · Hettinger, NDBuilt 1974 · S/N 17263087 N4334UTusko Air LLC · Choctaw, OKBuilt 1964 · S/N 15060334 N4335LClifford Gary G · Titusville, FLBuilt 1966 · S/N 17254404 N4335UHarrison Wesley V · Kemah, TXBuilt 1964 · S/N 15060335 N4336BAlthens Levi W · Wasilla, AKBuilt 1955 · S/N 26680 N4336LWiff Robert A · Tahuya, WABuilt 1966 · S/N 17254406 N4336MSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802472T N4337LWirt James · Goldsby, OKBuilt 1966 · S/N 17254408 N4337QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260237 N4337UStroope Jerry S · Pearland, TXBuilt 1964 · S/N 15060337 N4338LInsco Kay · Martin, TNBuilt 1966 · S/N 17254409 N4338QRegistration Pending · Salisbury, NCRegistration pendingBuilt 1971 · S/N 17260238 N4338RThompson Group Inc · Stockton, CABuilt 1974 · S/N 17263091 N4339BCurrie Andrew C · Oscoda, MIBuilt 1955 · S/N 26683 N4339QC & K Aero LLC · La Valle, WIBuilt 1971 · S/N 17260239 N4339RBurke Brian · Westlake, OHBuilt 1974 · S/N 17263092 N433EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11455 N433FRKtoa Rentals LLC · Torrance, CABuilt 1997 · S/N 17280292 N433KHHooey Kevin M · Corning, NYS/N 337M0139 N433LLSkydive Coolidge Inc · Tempe, AZBuilt 1963 · S/N 18254737 N433PTPilot Training Center LLC · Miami, FLBuilt 1974 · S/N 17263088 N433RMRocky Mountain College · Billings, MTBuilt 1974 · S/N 17262914 N433SBRico Kermot Aviation LLC · San Clemente, CABuilt 1969 · S/N 18259876 N433SPAspire Aviation LLC · Farmingdale, NYBuilt 1999 · S/N 172S8301 N433WKingdom Air Corps · Sutton, AKBuilt 1953 · S/N 25962 N4340BMuehl John M · Maryland, NYBuilt 1955 · S/N 26684 N4340UBenford Kenneth R · Haleyville, ALS/N 15060340 N4341LCut And Snip Flyers LLC · South Weber, UTBuilt 1966 · S/N 17254412 N4341ROleary Paul V · Gold Creek, MTBuilt 1974 · S/N 17263094 N4342LChenaille Lawrence A · Martinsville, INBuilt 1966 · S/N 17254413 N4343LDiamond C Aviation LLC · Gentry, ARBuilt 1966 · S/N 17254414 N4343QK M Air Enterprises Inc · Corona, CABuilt 1971 · S/N 17260243 N4343REndless Sky Aviation Inc · Syracuse, NYBuilt 1974 · S/N 17263096 N4343UBurke Jonathan D · Gaylord, MIS/N 15060343 N4344BMckinnon Harvey T · Thompson Falls, MTBuilt 1955 · S/N 26688 N4344LTorbett William H Jr · Stockbridge, GABuilt 1966 · S/N 17254415 N4344UKelly John M · Gastonia, NCS/N 15060344 N4345QNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1971 · S/N 17260245 N4345UCaskey Martin K · Paso Robles, CABuilt 1964 · S/N 15060345 N4346QCorrado Christian Blake · South Point, OHBuilt 1971 · S/N 17260246 N4346RFlyhnz LLC · Oxford, NCBuilt 1974 · S/N 17263097 N4347LChristiansen Steven P · Spokane, WAS/N 17254418 N4347RAvair LLC · Westville, INS/N 17265205

Back to AD 79-10-14 R1