Registered aircraft · 17,028

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N8161LNexten Flight Academy · Riverside, CABuilt 1967 · S/N 17256361 N8161UKaiser James · Fond Du Lac, WIBuilt 1964 · S/N 17252061 N8162FWeishuhn Charlie D · La Grange, TXBuilt 1966 · S/N 15064262 N8162MMeggers Darin R · Baker, MTBuilt 1972 · S/N 15073212 N8162ULunger Eric K · Mifflintown, PABuilt 1964 · S/N 17252062 N8163UCave Mark A · Snyder, TXBuilt 1964 · S/N 17252063 N8164LBowtie Properties LLC · Dadeville, ALBuilt 1967 · S/N 17256364 N8165FMoat William A · Braselton, GAS/N 15064265 N8165SDickey Jenni M · Willow, AKBuilt 1965 · S/N 15061765 N8165UFena Daniel J · Side Lake, MNS/N 17252065 N8165ZHenry Kenneth S Trustee · Kingman, AZBuilt 1962 · S/N 205-0165 N8166FHassan Nabil Ibrahim · Victorville, CABuilt 1966 · S/N 15064266 N8166LBlackerby Dennis N · Wilsonville, ALBuilt 1967 · S/N 17256366 N8166ZBronson Robert D Trustee · Prineville, ORBuilt 1962 · S/N 2050166 N8167LVan Pelt Wilbur F · Seattle, WABuilt 1967 · S/N 17256367 N8167SReid Bryce · Oklahoma City, OKBuilt 1965 · S/N 15061767 N81689Feisthamel Robert R · Mount Vernon, MOBuilt 1965 · S/N 18256235 N8169FRegistration Pending · Parker, KSRegistration pendingBuilt 1966 · S/N 15064269 N8169LApex Flight Training LLC · Houma, LABuilt 1967 · S/N 17256369 N8169UThorn Mark · Vashon, WABuilt 1964 · S/N 17252069 N816LRegistration Pending · Anderson, SCRegistration pendingBuilt 1968 · S/N 17256833 N81708Adventist World Aviation Inc · Wilson, NCS/N 18260156 N8170UFields William B · Climax, NCBuilt 1964 · S/N 17252070 N8170ZJones Kevin C · Leander, TXBuilt 1962 · S/N 2050170 N8171LSam Aviation LLC · Long Beach, CAS/N 17256371 N8171SLeavitt Adam · Boulder City, NVS/N 15061771 N8172FButler Donald S · Oak Ridge, NCBuilt 1966 · S/N 15064272 N8172UPrice Paul S · Camano Island, WABuilt 1964 · S/N 17252072 N8173FJohnson Jacob A · Shawnee, OKS/N 15064273 N8174FRangefinder Aviation LLC · Fort Collins, COS/N 15064274 N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574 N8174UJenson James H · Downers Grove, ILBuilt 1964 · S/N 17252074 N8174ZBishop Ronald E · Rolling Hills, CABuilt 1962 · S/N 2050174 N8175SAnderson Marcus D · Memphis, TNBuilt 1965 · S/N 15061775 N8175UN8175u LLC · Rosemount, MNS/N 17252075 N8176LAdams David F · South Lyon, MIBuilt 1967 · S/N 17256376 N81775Flying B Aviation LLC · Waynesboro, TNBuilt 1967 · S/N 17255171 N8177FLong Steven J · Amery, WIBuilt 1966 · S/N 15064277 N8177LDenton Scotchie M · Calhoun City, MSS/N 17256377 N8177ZWilliams Dutch R · Mohave Valley, AZBuilt 1962 · S/N 205-0177 N8178LMalone Traci L M · Effingham, ILBuilt 1967 · S/N 17256378 N8178ZCameron Joseph · Tucson, AZBuilt 1963 · S/N 205-0178 N8179DGarza Jose R Jr · West Jordan, UTBuilt 1971 · S/N 177RG0009 N8179LExecutive Wings LLC · Bolivar, TNBuilt 1967 · S/N 17256379 N8179SOllantair LLC · Chicago, ILBuilt 1965 · S/N 15061779 N817PSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 17252705 N818High Alpha Airshows LLC · Santa Rosa Valley, CABuilt 1968 · S/N 15069651 N8180LManser Andrew R · Neenah, WIBuilt 1967 · S/N 17256380 N8180MLeap Aviation Inc · Wilmington, DES/N 17260570 N8180ZAikins Nicholas O · Renton, WABuilt 1962 · S/N 205-0180

Back to AD 72-03-03 R3