OpenAirDocs.org
AD 72-01-07

Registered aircraft · 1,150

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
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-01-07')
    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-01-07')
  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.

N1009AWilliams Wendell · Anchorage, AKBuilt 1950 · S/N 18581N100SXKing Samuel E · Battle Mountain, NVBuilt 1951 · S/N 18-709N1011AMachamer John K · Gettysburg, PABuilt 1950 · S/N 18-582N1012ASimmons Michael T · Carolina Beach, NCBuilt 1950 · S/N 18-588N1017AEllis Wendell K · Gakona, AKBuilt 1950 · S/N 18-587N101KCH O Aircraft Inc · Maple Grove, MNS/N 18-649N101SCAnderson Benjamin T · Havre De Grace, MDBuilt 1964 · S/N 18-6200N1023AWhite Leland T · Deer Park, WABuilt 1951 · S/N 18-595N1023NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 18-1889N1029ALange Cole Kenneth · Oglala, SDBuilt 1954 · S/N 18-600N102LWWulff Allan · Reston, VABuilt 1955 · S/N 18-4383N102TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1954 · S/N 18-2216N1034AHawk Don · Shady Cove, ORS/N 18-606N10404Powers Phillp K · Tallulah, LAS/N 18-3561N1041AWinkelman Donald L · Anchorage, AKBuilt 1951 · S/N 18-619N1042APetrie Michael · Chugiak, AKBuilt 1951 · S/N 18-616N1043KShadowens Jackie R · Sapulpa, OKBuilt 1954 · S/N 18-3919N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622N1047VPoulter Thomas R · Chelsea, MIBuilt 1954 · S/N 18-3911N1048AUnderdahl Kirby L · Hamilton, MTBuilt 1951 · S/N 18-626N104TCarey Daniel F · Rockville Centre, NYS/N 18-2218N1050AMcmahan Charles B · Gakona, AKBuilt 1951 · S/N 18-628N1051ARegistered aircraftBuilt 1951 · S/N 18-641N10572Jefferson Jake O · Wasilla, AKS/N 18-933N1059AButler Billy D · Hilger, MTBuilt 1951 · S/N 18-630N105JCHeckathorn Chad W Trustee · Elk Point, SDBuilt 1950 · S/N 18-308N105TPeterson Nathan C · Cordova, TNBuilt 1952 · S/N 18-2219N1065ANordhaus Robert · Lake Geneva, WIBuilt 1951 · S/N 18-648N1066AYounggren James H · Hallock, MNBuilt 1951 · S/N 18-646N1069ALemmer Mark D · Atkinson, NEBuilt 1951 · S/N 18-652N1072AScarboro Thomas E · North Pole, AKBuilt 1951 · S/N 18-655N1073APeters Steven M · Parkersburg, WVBuilt 1951 · S/N 18-657N1075ABates Hobart C · Dexter, MIBuilt 1951 · S/N 18-667N1076ATri City Airframe LLC · Kalispell, MTS/N 18-659N1078AHall Alan R · Enumclaw, WABuilt 1957 · S/N 18-662N1081AHoyer Larry B · Fort Peck, MTBuilt 1951 · S/N 18-663N10842Cranor Douglas R · Valdez, AKBuilt 1951 · S/N 18-671N1087AScotton Bradley D · Galena, AKBuilt 1951 · S/N 18-673N1089AReeder Julian S Jr · Nenana, AKS/N 18-680N108TOlson Isaac B · Forestburg, SDBuilt 1952 · S/N 18-2222N1097ARanch Aero LLC · Sterling City, TXS/N 18-685N1099YJohnson Terry M · Wolfforth, TXS/N 18-1944N1103AUmlauf Paul M · Soldotna, AKBuilt 1951 · S/N 18-691N1104AHill Brock E · Palouse, WABuilt 1951 · S/N 18-692N1105AVan Voast Mark A · Turner, MTBuilt 1951 · S/N 18-693N1106AMountain Air Spray Co · Craig, COBuilt 1951 · S/N 18-694N1109AOrton Aviation LLC · Walker, MNBuilt 1951 · S/N 18-701N1109JOrton Aviation LLC · Walker, MNBuilt 1950 · S/N 18-392N1109WOrton Aviation LLC · Walker, MNBuilt 1957 · S/N 18-5946N1111AKnutson Wayne R · Tioga, NDBuilt 1951 · S/N 18-703
Back to AD 72-01-07