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.

N443RVHansen Eric B · Freeland, WABuilt 2005 · S/N 90443 N443TTGudsteinn Thor Thordarson · La Porte, INS/N 161 N44400Vonditsianou Michalis · Milpitas, CABuilt 1974 · S/N 28-7405239 N44407Kroneck Timothy S · Plymouth, WIBuilt 1974 · S/N 28-7425409 N4440LHutchison John · Big Lake, AKBuilt 1979 · S/N 187909169 N4440PApac LLC · Berlin, NJBuilt 1961 · S/N 23-1957 N4440ZThompson Logan T · Alliance, NEBuilt 1969 · S/N 18-8784 N44411Ruiz Raul · Sugar Land, TXBuilt 1974 · S/N 28-7415633 N44412J Mar Corp · Pittsburgh, PABuilt 1974 · S/N 28-7415634 N44413Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405241 N4441JPinkston Lance C · Batesville, ARBuilt 1967 · S/N 28-22846 N4441RAtwood Flying Club · Atwood, KSBuilt 1974 · S/N 17263184 N4441ZThoft Matthew M · Wasilla, AKS/N 18-8785 N44420England James M · West Paducah, KYBuilt 1974 · S/N 28-7415635 N44421Rojas Alissa · Warwick, RIBuilt 1974 · S/N 28-7415636 N44429Bettencourt David A · Dayville, CTBuilt 1974 · S/N 28-7415638 N4442AVella La Cava Air LLC · Albuquerque, NMBuilt 1956 · S/N 22-3772 N4442XHayes Kevin R · Richmond Hill, GABuilt 1975 · S/N 28-7625034 N4442ZKrutzfeldt John · Powderville, MTFirst renewal noticeBuilt 1969 · S/N 18-8786 N44430Red Eye Aviation LLC · Minocqua, WIBuilt 1974 · S/N 28-7405242 N4443AVollman Merlin · Pearland, TXBuilt 1956 · S/N 22-3773 N4443TKristofzski John · West Richland, WABuilt 1971 · S/N 28-7105228 N4443ZMeekin Michael J · Palmer, AKBuilt 1969 · S/N 18-8788 N44442Cummins Stephen Michael · Fenton, MOBuilt 1974 · S/N 28-7405244 N4444AWesolowski Chris E · Anchorage, AKBuilt 1956 · S/N 22-3774 N4444EIllsley Roger J · Santa Rosa, CABuilt 1976 · S/N 28-7690250 N44450Brown Roy A · Morongo Valley, CABuilt 1974 · S/N 28-7425412 N44452Cdr Aviation LLC · Kalispell, MTS/N 28-7425413 N4446JScherr Steven · Mandan, NDBuilt 1967 · S/N 28-22850 N4446RSiler Jerry L · Eau Claire, WIBuilt 1974 · S/N 17263188 N4446ZGrant Kimberly A · Priest River, IDBuilt 1969 · S/N 18-8792 N44478Richard J Farmer II · Fremont, OHBuilt 1974 · S/N 28-7405247 N4447QWolter Dennis R · Cincinnati, OHBuilt 1973 · S/N 17261719 N44485Registration Pending · Middletown, OHRegistration pendingS/N 28-7415646 N44488Daris James · Fitzwilliam, NHBuilt 1974 · S/N 28-7415647 N4448THoughton John L · Lamar, MOBuilt 1971 · S/N 28-7105227 N4448ZGrow Michael J · Palmer, AKBuilt 1969 · S/N 18-8795 N44497English William E · Mason City, IABuilt 1974 · S/N 28-7425417 N4449JSinatra Anthony J · Glendale, AZBuilt 1967 · S/N 28-22854 N4449ZStenga James E · Soldotna, AKBuilt 1969 · S/N 18-8796 N444AWHangar 22 LLC · Wilmington, DEBuilt 1995 · S/N 373-95 N444BLTri Air LLC · Monette, ARBuilt 1966 · S/N 99 N444CSStover Charles S · Ft Lupton, COBuilt 2001 · S/N 3994 N444DBBalint Jozef · Fort Worth, TXBuilt 1978 · S/N 7-0106 N444DDHardin Donald D Trustee · Kirkwood, MOBuilt 1983 · S/N 1423 N444DJSims George W III · Eclectic, ALBuilt 1970 · S/N 700075 N444EEVaughn Stewart C · West Jordan, UTBuilt 1974 · S/N 17263906 N444FEN444fe LLC · Stuart, FLBuilt 1979 · S/N ME-142 N444FGFrancis Andrew J III · Spring, TXBuilt 1981 · S/N 28-8190283 N444JGGrimmonpre Mark D · Fort Walton Beach, FLBuilt 1968 · S/N 17257013

Back to AD 79-10-03 R2