Skip to content

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.

N8007FSimms Peter W · Wellsville, NYFirst renewal noticeS/N 15064107 N8007GBradford Steven M · Muscatine, IABuilt 1970 · S/N 177RG0007 N8007SGolden Aerial Services LLC · Erie, PABuilt 1965 · S/N 15061607 N8008GMentgen William P · Greencastle, INBuilt 1970 · S/N 177RG0008 N8009FRucinski Edward A · Climax, NCBuilt 1966 · S/N 15064109 N800FMartin Tyler · Waco, TXBuilt 1964 · S/N 205-0520 N800FCFargo Curt J · Vacaville, CAS/N 17256726 N800HEFredericks Kenneth L · Halliday, NDBuilt 1965 · S/N 15061602 N800LC54 Aero LLC · Spade, TXBuilt 1968 · S/N 18258879 N800MLNaples LLC · Mound City, MOBuilt 1966 · S/N 18257132 N8010FTorres Mora Jose Alberto · Modesto, CABuilt 1966 · S/N 15064110 N8010LLegion Flying Club Inc · Springfield, MABuilt 1967 · S/N 17256210 N8010ZRosander Mining Co Inc · Mc Grath, AKBuilt 1965 · S/N U206-0410 N8011GLadner Marvin D · Sidney, NYBuilt 1970 · S/N 177RG0011 N8011LLaska Lonny J · Tonawanda, NYBuilt 1967 · S/N 17256211 N8011ZJackson Jet Center · Boise, IDS/N U206-0411 N8012FHood William T · Columbia, SCBuilt 1966 · S/N 15064112 N8012SCollins Scott · Upland, CABuilt 1965 · S/N 15061612 N8013LCarroll Connie S · Clyde, TXBuilt 1967 · S/N 17256213 N8013SRedmond Angela L · Austin, TXBuilt 1965 · S/N 15061613 N8014SMurray Bart · Pacifica, CAS/N 15061614 N8015FLewis L Dwight Jr · Lopez Island, WABuilt 1966 · S/N 15064115 N8015ZKennedy Kerry D · Anchorage, AKBuilt 1965 · S/N U206-0415 N8017LOgle Randall W · Wenatchee, WABuilt 1967 · S/N 17256217 N8017SHughes Todd R · Rocky Ford, COS/N 150-61617 N8019FLyman Kenneth R · Livermore Falls, MEBuilt 1966 · S/N 15064119 N8019LSleeping Giant Flying Club Inc · Helena, MTBuilt 1967 · S/N 17256219 N8019ZGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1965 · S/N U206-0419 N8021SKoehn Mark W · Elkader, IAS/N 15061621 N8022GAaron Arthur Harrison · Gold River, CABuilt 1970 · S/N 177RG0022 N8023SBalles Jeffrey J Sr · Hunker, PABuilt 1965 · S/N 15061623 N8024GRedwing Aviation LLC · San Antonio, TXBuilt 1970 · S/N 177RG0024 N8024SOmlid Robert L · Watford City, NDBuilt 1965 · S/N 15061624 N8025FFurlong Kelly L · Athens, ALBuilt 1966 · S/N 15064125 N8025GN8025g C177rg LLC · Jeffersonville, INBuilt 1970 · S/N 177RG0025 N8025SBranch Timothy · Russellville, ARBuilt 1965 · S/N 15061625 N8026FCardoza Bren J · Port Hueneme, CABuilt 1966 · S/N 15064126 N8026LSayers Carl D · Vidalia, LABuilt 1967 · S/N 17256226 N8027GBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 177RG0027 N8027LVan Kirk Malcolm R · Frederick, MDBuilt 1967 · S/N 17256227 N8028GAndersen Timothy R · Elizabeth City, NCBuilt 1970 · S/N 177RG0028 N8029GIndy Air Sales LLC · Anderson, INBuilt 1970 · S/N 177RG0029 N8029LBeasley Marvin T · Vidalia, GABuilt 1967 · S/N 17256229 N8029SPapich William · Boston, NYBuilt 1965 · S/N 15061629 N802UMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700067 N8030LScala Anthony J · New Hyde Park, NYBuilt 1967 · S/N 17256230 N8030SWatson William E · Glen Rose, TXBuilt 1965 · S/N 15061630 N8031FDevine Steven Anthony · Gilbert, AZS/N 15064131 N8031GFletcher Craig B · Willis, TXBuilt 1970 · S/N 177RG0031 N8032LCorbin Air Inc · Saint Clair Shores, MIBuilt 1967 · S/N 17256232

Back to AD 72-03-03 R3