Skip to content

Registered aircraft · 40,394

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.

N7530WSohl Virginia · Farmingdale, NYBuilt 1963 · S/N 28-1452 N75315Abilene Fyling Service Inc · Abilene, KSBuilt 1976 · S/N 28-7615287 N7531WZmrzel David J · Port Saint Lucie, FLBuilt 1963 · S/N 28-1455 N75320Strickland Plumbing Hvac And Electric Inc · Lufkin, TXS/N 28-7690329 N75327Karr Eric · Eau Claire, WIBuilt 1976 · S/N 28-7625214 N7532KRegistration Pending · Eagle River, AKRegistration pendingBuilt 1950 · S/N 18-248 N7532RSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3554 N7532SSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3630 N7532WWirthlin Donald K · Sierra Vista, AZBuilt 1963 · S/N 28-1456 N75336Warthog Aviation Inc · Grand Island, NYBuilt 1978 · S/N 28-7890080 N7533DFranz Barrett C · Bay City, TXBuilt 2004 · S/N 3643 N7534LNovember Alpha LLC · Los Angeles, CABuilt 2004 · S/N 3650 N7534PCrow Brenton · Findlay, OHBuilt 1961 · S/N 24-2738 N7534RVitrano Mike A · Culleoka, TNBuilt 1966 · S/N 28-22095 N75352Toledo Jorge G · Coral Gables, FLS/N 28-7615294 N7535HKronfuss Edward P · Bozeman, MTBuilt 1946 · S/N 12401 N7535RDuval Daniel · Hohenwald, TNBuilt 1966 · S/N 28-22097 N7536BAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3688 N7537PWright Neal W · Hillsboro, ORBuilt 1961 · S/N 24-2742 N7537REconomou Brian P · Auburn, CABuilt 1966 · S/N 28-22099 N7537WWindous Darin T · Spring Creek, NVBuilt 1963 · S/N 28-1470 N75381Doublewide Holdings LLC · Three Rivers, CABuilt 1976 · S/N 28-7615295 N75382FAA Flying Club Inc · Springfield, VABuilt 1976 · S/N 28-7615296 N75383Beaman Brice S · Alger, OHBuilt 1976 · S/N 28-7690335 N75384Primost Brian C · North Brunswick, NJBuilt 1976 · S/N 28-7690336 N7538DOeser Laura Ann · La Grange, TXBuilt 1957 · S/N 22-5268 N7539DEaa Chapter 99 Inc · Vero Beach, FLS/N 22-5269 N7539FHerkstroeter Caleb · Fairbanks, AKS/N 210-70 N7539RShanahan Michael P · Cottage Grove, ORS/N 28-22101 N7539WMccormick Michael J · Pocatello, IDBuilt 1963 · S/N 28-1472 N753JBCraig Connor J · Mesa, AZBuilt 1966 · S/N 3377 N7540DVanhouten Eric · Tunkhannock, PAS/N 22-5270 N7540FMeierotto Noah J · Two Rivers, AKBuilt 1969 · S/N 211-70 N7540GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259240 N7541RHoover Michael H · Baxter, TNBuilt 1966 · S/N 28-22103 N7541WPiaquadio Dennis J · Newburgh, NYBuilt 1963 · S/N 28-1474 N7542GNelson Frank H · Tuscaloosa, ALBuilt 1970 · S/N 17259242 N7542RCarr Scott A · Allen, NEBuilt 1966 · S/N 28-22104 N7542WRegistration Pending · Rush City, MNRegistration pendingBuilt 1963 · S/N 28-1475 N7543DBerg Butch A · Duluth, MNBuilt 1957 · S/N 22-5274 N7543GTrue Course LLC · West Monroe, NYBuilt 1970 · S/N 17259243 N7543WHobbs Michael S · Midland, TXBuilt 1964 · S/N 28-1516 N7544RReyes Aviation Inc · Middletown, DEBuilt 1966 · S/N 28-22339 N7544WSchrag Douglas R · Pretty Prairie, KSBuilt 1963 · S/N 28-1477 N7545KSnead Doug · Derby, KSBuilt 1950 · S/N 18-261 N7545RWoodworth Rachel L · Louisville, KYBuilt 1966 · S/N 28-22107 N7545W7545w LLC · Liberty, SCBuilt 1963 · S/N 28-1478 N7547DHawkins Laurie M · Birch Run, MIBuilt 1957 · S/N 22-5278 N7547GMutter William D · Chelan, WABuilt 1970 · S/N 17259247 N7547RGreene Peter Clune · Sag Harbor, NYBuilt 1966 · S/N 28-22109

Back to AD 79-10-03 R2