Skip to content

Registered aircraft · 54,017

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N52767Loudy William E · Rigby, IDBuilt 1974 · S/N 18262834 N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341 N5276ESchmutz George L · Atascadero, CABuilt 1983 · S/N 18268306 N5276MBruehl Kenneth · Roseville, CABuilt 1980 · S/N 15284513 N5276QCarter Nolon D · Kirksville, MOBuilt 1972 · S/N 15073176 N5276SParke Travis · Rancho Cucamonga, CAS/N R18201535 N5276VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 21060891 N52775Pa-18 LLC · Hood River, ORBuilt 1974 · S/N 18262837 N5277EJefredo Corp · Zephyrhills, FLS/N 17271809 N5277JYr-Aircraft Leasing LLC · Bethel, AKBuilt 1984 · S/N 20700772 N5277PBennett Glenn D · Kingwood, TXBuilt 1977 · S/N 21061784 N5277VLechner Gary D · Woodstock, ILBuilt 1975 · S/N 21060892 N52781Mckendry Martin · Carmel Valley, CABuilt 1974 · S/N 18262840 N52783Valdes Alfonso · El Paso, TXBuilt 1974 · S/N 18262842 N52786Moore Roger · Jonesboro, ARBuilt 1977 · S/N 177RG1270 N52789Alameda Aero Club · Alameda, CABuilt 1981 · S/N 17274607 N5278DN5278d LLC · Dover, DEBuilt 1979 · S/N 17272488 N5278ESeasholtz John O · Fresno, CABuilt 1979 · S/N 18503949 N5278QRegistration Pending · Madison, MSRegistration pending, canceledBuilt 1972 · S/N 15073178 N5278RHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17263492 N5278VZubrod John W · Ebony, VABuilt 1977 · S/N R1722285 N52791Gibson James W · San Antonio, TXS/N 177RG1271 N52792Ball Richard W · Ridgefield, CTBuilt 1974 · S/N 18262848 N52795Key Lime Consultants LLC · Belleview, FLS/N 18262851 N52797Supinie Andy · Wichita, KSBuilt 1974 · S/N 18262852 N5279DDay Aviation Inc · Wilmington, DEBuilt 1979 · S/N 17272489 N5279GArnold Jason Mcree · Watkinsville, GABuilt 1979 · S/N 17273558 N527AAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1976 · S/N 15078287 N527ANDaisy Aviation LLC · Beavercreek, OHBuilt 1965 · S/N 17252779 N527BMMarc Inc · Bolton, MSS/N P2060035 N527CAIsaacson Scott D · San Diego, CABuilt 1977 · S/N R172-2510 N52800Jackson Royalties Inc · Brandon, MSBuilt 1977 · S/N 177RG1273 N52802Gune Abhijit P · Dublin, CABuilt 1977 · S/N 177RG1274 N52805Conover Mark D · Santa Cruz, CABuilt 1977 · S/N 177RG1275 N52806Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17274610 N52808Thane Inc · Elkridge, MDBuilt 1974 · S/N 18262862 N5280EStreeter Byrand DBA · Newcastle, WYBuilt 1978 · S/N 17271810 N5280MN5280m LLC · Elizabeth, COBuilt 1979 · S/N 17273671 N5280T368 Air 2 LLC · Higley, AZS/N R1722850 N5280UStrantz Roger J · Denton, TXBuilt 1980 · S/N 172RG0320 N52812Northern Air Inc · Bonners Ferry, IDBuilt 1974 · S/N 18262866 N52814Hyduke Robert Alan · Port Matilda, PABuilt 1977 · S/N 177RG1277 N52815S & S Aircraft Inc · Bennington, VTBuilt 1981 · S/N 17274612 N52818Aeroluxe Aviation LLC · Nashville, TNBuilt 1981 · S/N 17274615 N5281DRocky Pointe Logistics LLC · Hayden, IDBuilt 1958 · S/N 50179 N5281JHowell Jason · Newaygo, MIBuilt 1980 · S/N 17273753 N5281QHhd Aviation LLC · Hamilton, OHS/N 15073181 N5281VOne Vector LLC · Wolcott, COBuilt 1975 · S/N 21060896 N52820Morrison Wanda L · Farmington Hills, MIS/N 17274616 N52821Big Bird Aerial Photography LLC · Astoria, ORBuilt 1974 · S/N 18262871

Back to AD 87-20-03 R2