Registered aircraft · 17,027

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.

N6597GOff Airport Adventures LLC · Saint David, AZBuilt 1971 · S/N 15072097 N65981Registration Pending · Dubuque, IARegistration pendingBuilt 1974 · S/N 15075756 N65984Woelbing Aviation LLC · Franksville, WIBuilt 1974 · S/N 15075758 N65985Moreira Hiosvany · Pensacola, FLS/N 15075759 N65986Ahern Michael · El Reno, OKBuilt 1974 · S/N 15075760 N65997Dalton John C · Hernando, MSBuilt 1974 · S/N 15075764 N6599FSiebe James E · Moscow, IDBuilt 1966 · S/N 15063199 N65AMDorroh Frederick A · Ardmore, OKBuilt 1968 · S/N 18259022 N65CFSanders David T · Flagstaff, AZBuilt 1962 · S/N 18254365 N65DPPilawski Darren · Spring Hill, FLS/N 17257299 N65KSSauceda Juan B · Austin, TXBuilt 1965 · S/N 18256481 N65PKOlson'S Excavating Inc · Cascade, IDBuilt 1966 · S/N 18257491 N65PTBs Aviation LLC · Portland, ORBuilt 1976 · S/N 177RG1086 N65SUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1968 · S/N 0496 N65WBMckamey Robert S · Tullahoma, TNBuilt 1966 · S/N 17254426 N66006Registration Pending · Souderton, PARegistration pendingBuilt 1974 · S/N 15075769 N66009Cowan Ronnie C · Glasgow, KYBuilt 1974 · S/N 15075772 N6600DMarsh John E · Washington, DCS/N 15072100 N6600FSeiger Thomas W · Medford, ORS/N 15063200 N66017Engelhardt John · Kingwood, TXFirst renewal noticeBuilt 1974 · S/N 15075778 N6602FBeasley Thomas · Fort Worth, TXS/N 15063202 N6603FAres Andrey · Fort Lauderdale, FLBuilt 1966 · S/N 15063203 N6603SColonial Air Inc · New Bedford, MABuilt 1967 · S/N 15067403 N6606GRoach Georgia L · Dewitt, ARBuilt 1970 · S/N 15072106 N6607FRegistered aircraftBuilt 1966 · S/N 15063207 N6609FMcalexander William Dean · Conover, OHBuilt 1966 · S/N 15063209 N660MRWilson Process Instrumentation Calibrations Inc · Muskegon, MIS/N 18258984 N660SRAom Aircraft LLC · Orlando, FLBuilt 1968 · S/N 17701151 N660TAReinhardt Anthony C · Duchesne, UTBuilt 1970 · S/N 17259612 N6610FCabala Nicholas C · Bay City, MIBuilt 1966 · S/N 15063210 N6610GThomas Charles L · Yankton, SDBuilt 1970 · S/N 15072110 N6611FMehsling Thomas C · Byers, COBuilt 1966 · S/N 15063211 N6611XNelson Ann · Box Elder, SDBuilt 1963 · S/N 18254798 N6612FG & M Holdings LLC · Cedar Rapids, IABuilt 1966 · S/N 15063212 N6614GDonaldson Charles R · Marfa, TXS/N 15072114 N6615SStott Thomas W · Fort Shaw, MTBuilt 1967 · S/N 15067415 N6616GSale Reported · Pineville, LASale reported, pending cancellationS/N 15072116 N6617GGeneral Aviation Holdings LLC · Port Orange, FLBuilt 1970 · S/N 15072117 N6617SKembel Robert D · Saint Ignatius, MTS/N 15067417 N6618GKonkle Tyrel J · Morristown, TNBuilt 1970 · S/N 15072118 N6618SLipski Robert · Wallingford, CTBuilt 1967 · S/N 15067418 N6619GKlenptner Lori Jo · Henderson, NVS/N 15072119 N6619SFun Flight Training LLC · Bartow, FLS/N 15067419 N661DDHanisko Thomas F · Mount Shasta, CAS/N 15067508 N661KFurrow Terry · Hinton, OKBuilt 1978 · S/N 177RG1311 N6620FHole In The Clouds Rentals LLC · Montgomery, ALBuilt 1966 · S/N 15063220 N6620GN6620g LLC · Monticello, INBuilt 1970 · S/N 15072120 N6620SFellegy James M · Mauston, WIBuilt 1967 · S/N 15067420 N6622GSky High Adventures LLC · Wilmington, DES/N 15072122 N6623SWilliams Nathan · Von Ormy, TXBuilt 1967 · S/N 15067423

Back to AD 72-03-03 R3