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.

N5123RGiving Wings Aviation LLC · Traverse City, MIBuilt 1974 · S/N 17263341 N5123TSlaughter Patricia C · Saranac, MIBuilt 1966 · S/N 122 N5123VAustin Jeffrey L Trustee · Salem, ORBuilt 1961 · S/N SP-19 N5123WVaughn Jesse L · Poplar Bluff, MOBuilt 1961 · S/N 28-149 N51240Young Roger P · Sewickley, PABuilt 1980 · S/N 17274288 N51249Flying Turkey LLC · Flower Mound, TXBuilt 1974 · S/N 17264230 N5124EHarris Russell Farrell · Chino Valley, AZBuilt 1978 · S/N 17271723 N5124JAbove And Beyond Aviation LLC · Austin, TXS/N 17273710 N5124LCrisp Phil · Greencastle, PABuilt 1967 · S/N 28-4407 N5124RGarrison Randy L · Queen City, TXBuilt 1974 · S/N 17263342 N5124VAuiler Casey M · San Diego, CABuilt 1961 · S/N SP-20 N51254Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274291 N5125DValdes Eusebio · Miami, FLBuilt 1974 · S/N 17264231 N5125GRogers William A II · Indn Hbr Bch, FLBuilt 1968 · S/N 17257022 N5125MSampson Alan T · Indianapolis, INBuilt 1978 · S/N M-2030 N5125PWalton Josh A · Westcliff, COBuilt 1958 · S/N 24-138 N5125VKalchev Dimitar · Fishers, INBuilt 1961 · S/N SP-21 N5125WElyon Holdings LLC · Gulf Shores, ALBuilt 1961 · S/N 28-151 N5125XBaker Daniel E · Saint Petersburg, FLS/N 114 N5126EHouk Sean R · Lyons, OHBuilt 1978 · S/N 17271724 N5126GMag-Aero Inc · Harvard, ILBuilt 1979 · S/N 17273551 N5126QAvco Patrol LLC · Lyndon, KSBuilt 1973 · S/N 17261757 N5126RAirborne Investors Corp · Buford, GABuilt 1974 · S/N 17263343 N5126SRyan Kevin M · Xenia, OHBuilt 1971 · S/N 28-7105173 N5126VSkylark Flight Training LLC · Wilmington, DEBuilt 1980 · S/N 172RG0452 N5126WCook Jackson W · Buckley, WAS/N 28-152 N5127GKurtz Joseph A · Hamilton, GAS/N 28-24675 N5127HSmith Dan R · Montrose, SDBuilt 1975 · S/N 17265344 N5127RAmerican Industrial Laundry · Lander, WYBuilt 1974 · S/N 17263344 N5127SWeston Thomas J · Stratford, NJBuilt 1971 · S/N 28-7125457 N5127VGriffy Paige E · Decatur, ILS/N SP-23 N5127YAirborne Extreme LLC · Wasilla, AKBuilt 1962 · S/N 18-7895 N5127ZPohland Charles A · Anchorage, AKBuilt 1961 · S/N 18-7765 N5128BEastman Gregory L · Pueblo, COBuilt 1980 · S/N 172RG0279 N5128DKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272430 N5128GSale Reported · Gainesville, FLSale reported, pending cancellationBuilt 1968 · S/N 28-24669 N5128LSquawk 2017 LLC · Flowery Branch, GABuilt 1967 · S/N 28-4411 N5128RBend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17263345 N5128SDonegan Martin A O · Bethlehem, PABuilt 1971 · S/N 28-7125512 N5128VBeulen Brian V · Mesa, AZBuilt 1961 · S/N SP-24 N51295Right Brother Aviation LLC · Chaffee, NYBuilt 1980 · S/N 17274295 N51297Ingram Dale D · Klamath Falls, ORS/N 17264232 N5129QWaters John E · Renton, WABuilt 1973 · S/N 17261758 N5129SSplendid Aviation Inc · Corpus Christi, TXBuilt 1971 · S/N 28-7125600 N5129VBirdzell Luther E · Hood River, ORBuilt 1961 · S/N SP25 N5129WStanek Kenneth W Jr · Russellville, ARBuilt 1961 · S/N 28-156 N5129YCarter Ronald Lynn · Nenana, AKS/N 12-1554 N512ACBuck James Kyle III · Oak Ridge, NCBuilt 1999 · S/N 1281-99 N512BLawler Glenn M · Mooresville, NCBuilt 1999 · S/N 2308 N512BWMontauk Catamaran Co LLC · Montauk, NYBuilt 1974 · S/N AA5-0702

Back to AD 79-10-03 R2