Skip to content

Registered aircraft · 40,396

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N4346QCorrado Christian Blake · South Point, OHBuilt 1971 · S/N 17260246 N4346RFlyhnz LLC · Oxford, NCBuilt 1974 · S/N 17263097 N4347DAviation Flight Services Inc · Cumming, GABuilt 1984 · S/N 28-8416081 N4347GPurdue Pilots Inc · West Lafayette, INBuilt 1984 · S/N 28-8416062 N4347HKillian Regina · Prosper, TXBuilt 1984 · S/N 28-8416063 N4347KRegistration Pending · Augusta, KSRegistration pendingBuilt 1984 · S/N 28-8416064 N43488Ravotti Air LLC · Leechburg, PABuilt 1974 · S/N 28-7415507 N4348FRegistered aircraftBuilt 1976 · S/N 28-7790018 N4348QStehouwer Todd J · Kentwood, MIBuilt 1992 · S/N 20771 N4348ZWilliams Reid G · Cantwell, AKBuilt 1968 · S/N 18-8645 N43493Henderson James A · Flomaton, ALBuilt 1974 · S/N 28-7415508 N4349FStriegel Jory D · Washington, DCS/N 28-7790019 N4349LParker Air LLC · Mobile, ALBuilt 1984 · S/N 28-8416068 N4349RVaughan James · Meansville, GABuilt 1974 · S/N 17263100 N4349TJrh Avgroup Inc · Satellite Beach, FLBuilt 1972 · S/N 28-7205147 N4349XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515447 N4349YSpence Willard J · Davin, WVBuilt 1984 · S/N 28-8416071 N434DSFranseen Steven R · Northglenn, COBuilt 1996 · S/N 266 N434FLPerkins Jeffrey E · Grand Prairie, TXBuilt 1971 · S/N 28-7125220 N434JVClark Nathaniel T · Duncanville, TXBuilt 1966 · S/N 28-3646 N434PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496064 N434RVRudolph Richard W · Fort Worth, TXBuilt 2001 · S/N 60434 N434WPZimmerman Justin W · Palmer, AKBuilt 1968 · S/N 28-5071 N43507Washington Joseph D · Springfield, ILBuilt 1974 · S/N 28-7415512 N4350RB2 West Corp · Winona, MNBuilt 1974 · S/N 17263101 N4350WHochbrueckner Timothy W · Mineola, NYBuilt 1974 · S/N MC-272 N4350ZBenning Gary R · Blue Grass, IABuilt 1968 · S/N 18-8667 N43511Freedom Development Corporation LLC · Rock Hill, SCBuilt 1974 · S/N 28-7405201 N4351QJohnson James Benjamin · Rosharon, TXBuilt 1971 · S/N 17260251 N4351RVertol Systems Co Inc · Destin, FLBuilt 1974 · S/N 17263102 N4352ABrito Angelo M · Dillingham, AKS/N 22-3708 N4352DAshdown Adrian · Canandaigua, NYBuilt 1984 · S/N 28-8416073 N4352GBouza Mario · Santa Clara, CABuilt 1984 · S/N 28-8416074 N4352RQuad City Area Flying Eagles · Milan, ILBuilt 1974 · S/N 17263103 N4352TJaycee Flying Club Inc · Mineral Ridge, OHBuilt 1971 · S/N 28-7205148 N4352XBackstreet Aviation LLC · Hickory, NCBuilt 1975 · S/N 28-7505191 N43530Pereira Jailton D · Elizabeth, NJBuilt 1992 · S/N 2933 N4353AVinson David L · Mc Alpin, FLBuilt 1956 · S/N 22-3709 N4353JStevens Fredric Dale · Tucson, AZBuilt 1967 · S/N 28-22731 N4353LSummit Flight Academy LLC · Peculiar, MOBuilt 1984 · S/N 28-8490062 N4353QHaley Paul M · Hillsboro, NHBuilt 1971 · S/N 17260253 N4353TJones Charles E Jr · Cottonwood, CAS/N 20117 N4353VDiehl David S B Jr · Frederick, MDBuilt 1993 · S/N 1996 N4353XCharriez Jose L Jr · East Elmhurst, NYBuilt 1975 · S/N 28-7515441 N43544Dibiaso Thomas F · Mount Laurel, NJBuilt 1974 · S/N 28-7415520 N4354PApache Twin Rental LLC · Harrisonville, MOBuilt 1960 · S/N 23-1854 N43550Browning Neil G · Tehachapi, CABuilt 1974 · S/N 28-7415521 N43555Klass Kenneth P · Nicholson, PABuilt 1974 · S/N 28-7415524 N43556Waddell Charles T · Elk Grove, CAS/N 28-7415525 N43559Smith Thomas Michael · Saint Cloud, MNBuilt 1974 · S/N 28-7425378

Back to AD 79-10-03 R2