Skip to content

Registered aircraft · 40,473

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N44355Registration Pending · Augusta, KSRegistration pendingBuilt 1974 · S/N 28-7415625 N44363Good Flight Aviation LLC · Stockton, CABuilt 1974 · S/N 28-7415626 N4436QVan Hoomissen Thomas J · Anchorage, AKS/N 17261715 N4436RDoran Kenneth J · Twisp, WABuilt 1974 · S/N 17263181 N4437XMarianas Air Transfer Inc · Saipan, MPBuilt 1975 · S/N 28-7625032 N44383B2w Corporation · Winona, MNBuilt 1974 · S/N 28-7415628 N4438ZCan-Am Aero LLC · Tulsa, OKBuilt 1969 · S/N 18-8781 N44397Tsfc Inc · Angola, INBuilt 1974 · S/N 28-7425408 N44399Glass Robert S Trustee · Costa Mesa, CABuilt 1974 · S/N 28-7415631 N4439AHenry Kirk S · Uhrichsville, OHBuilt 1956 · S/N 22-3768 N443ACSp Sun LLC · Half Moon Bay, CABuilt 2000 · S/N 442-2000 N443DTGraff Ricky D · El Campo, TXBuilt 1989 · S/N 65 N443ERivenbark Michael Keith · Clinton, NCS/N 102 N443FLPradhan Anis · Torrance, CABuilt 1971 · S/N 28-7125234 N443JBGuy Jeffrey · Centerburg, OHBuilt 1989 · S/N 20023 N443JGRose Benjamin A · Newberg, ORBuilt 2002 · S/N 60177 N443MWKarren Kade R · Mountain Home, IDS/N 21057 N443PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843499 N443RLGuinn Timothy J · Jennings, LABuilt 1996 · S/N 1223-96 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

Back to AD 80-04-03 R2