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.

N9460BEdwards Ag Service · Primghar, IABuilt 1958 · S/N 55260 N9460DOlsen Marr B · Kelseyville, CABuilt 1959 · S/N 18-6810 N9460JDerosa Michael D · Hewitt, TXBuilt 1966 · S/N 28-3573 N9461CClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890412 N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174 N9461JKobbeman Joseph B · Louisville, KYBuilt 1966 · S/N 28-3574 N9461PErickson Jess L · Saco, MTBuilt 1975 · S/N 18-7509133 N9461VZembraski Jeffrey · Nocona, TXBuilt 1970 · S/N 700056 N9462DEvans Randall Btrustee · Fallon, NVBuilt 1959 · S/N 18-6811 N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175 N9463KRegistered aircraftBuilt 1976 · S/N 28-7690253 N9463VHatcher Mark F · Aloha, ORBuilt 1970 · S/N 700057 N9464D907 Aviators LLC · Eagle River, AKBuilt 1958 · S/N 18-6707 N9464JReinert Roger J · Duluth, MNS/N 28-3578 N9465DMehrer Fritz J · Oceanside, CAS/N 172RG1176 N9465JTaylor Robert J · Woodbridge, VABuilt 1966 · S/N 28-3579 N9466DGerrard Michael K · Kaysville, UTS/N 18-6813 N9466EGood Flight Aviation LLC · Stockton, CABuilt 1979 · S/N 17272272 N9466JHawk Aviation Academy LLC · Saint Petersburg, FLBuilt 1966 · S/N 28-3580 N9466PNewton Bros · Stratford, CABuilt 1973 · S/N 18-7309016 N9467CDominy Alan L · The Woodlands, TXBuilt 1978 · S/N 28-7890413 N9467DHahn Randal N · Wasilla, AKBuilt 1951 · S/N 18-863 MC N9468DKelly Henry Searles · Ossining, NYBuilt 1984 · S/N 172RG1177 N9468HShouse Andrew · Flagstaff, AZBuilt 1975 · S/N 17266169 N9468JSheffield Glenn A · Houston, TXBuilt 1966 · S/N 28-3582 N9469DRanney Gayle · Cordova, AKBuilt 1959 · S/N 18-6815 N9469EParker Duane E · Louisville, KYBuilt 1979 · S/N 17272273 N9469HAirplanes And Attitude LLC · Mckinney, TXBuilt 1975 · S/N 17266170 N9469JNelson Stephen A · Milaca, MNBuilt 1966 · S/N 28-3584 N946CHCritchfield Flying Service LLC · Rupert, IDBuilt 1977 · S/N 17269021 N946CVLightcap Michael Wayne · Mc Alpin, FLBuilt 2000 · S/N 22004 N946GSStage George A · Kirtland, OHBuilt 2010 · S/N 2070-L N946PTBrillo Benjamin G · Union City, CABuilt 2002 · S/N 5739 N946SMEntrekin David C · Ridgeland, MSBuilt 1982 · S/N 17275870 N946TEStrange Bird LLC · Hackensack, NJBuilt 2003 · S/N 10225 N9470DJacko Josh E · Anchorage, AKBuilt 1959 · S/N 18-7016 N9471DRasmuson Travis R · Helena, MTBuilt 1959 · S/N 18-7018 N9471VJ S Alguire Consulting Forestry Services Inc · Dover, DEBuilt 1970 · S/N 700060 N9472HMulder Terry A · Appleton, WIBuilt 1976 · S/N 17266171 N9472JMarquette County Flying Club · Marquette, MIBuilt 1966 · S/N 28-3587 N9473DZweifel Douglas L · Anchorage, AKBuilt 1959 · S/N 18-7019 N9473JEncounter Inc · Piedmont, OKBuilt 1966 · S/N 28-3588 N9474BDiehl Greg · Angola, INBuilt 1981 · S/N 172RG0833 N9474JGerber Dennis J · Liverpool, NYBuilt 1966 · S/N 28-3589 N9474VCasa Patrick Greg · Albuquerque, NMBuilt 1970 · S/N 700061 N9475DRoe Dennis N · Fairbanks, AKBuilt 1958 · S/N 18-6725 N9475EBerzinis Wayne T · Windham, MEBuilt 1979 · S/N 17272275 N9476HHelicopter Partners Inc · Wellington, FLBuilt 1975 · S/N 17266172 N9476JNery Thomas A · Mansfield, MABuilt 1966 · S/N 28-3592 N9477DJ H Miller & Son Inc · Saint John, WABuilt 1958 · S/N 18-6729

Back to AD 79-10-03 R2