OpenAirDocs.org
AD 72-02-02

Registered aircraft · 217

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-02-02')
    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-02-02')
  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.

N100FMajor Kens Flying Service LLC · Colfax, NDBuilt 1972 · S/N 1021N10286Flying D Farm Inc · Kerhonkson, NYBuilt 1961 · S/N 86N118JDJacobson Luke W · Reno, NVS/N 863N127FCBurghduff Aviation LLC · Ludlow, SDS/N 1393N16AAMcpherson Timothy L · Page, NDBuilt 1971 · S/N 792N27SKKingsley Kiman J · Miller, MOBuilt 1974 · S/N 1341N29GWRegistration Pending · Tyler, MNRegistration pendingBuilt 1975 · S/N 1564N34TFAlbertson James M · Slocomb, ALS/N 1724N410XBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 631N4241Ham Orlando DBA · Opdyke, ILBuilt 1972 · S/N 1011N4244Kingsley Kiman J · Miller, MOBuilt 1973 · S/N 1034N4369Lewis Flying & Maint Svc Inc · Morse, LABuilt 1973 · S/N 1045N4450Registered aircraftS/N 1048N4508Page Marion E · Clio, SCBuilt 1973 · S/N 1050N4536Mid Continent Aircraft Corp · Hayti, MOBuilt 1973 · S/N 1053N4591Kramr David J · Lissie, TXBuilt 1973 · S/N 1066N4623Breum Sean M · Stanwood, WABuilt 1973 · S/N 1087N4630Jones Aviation Inc · Biggs, CABuilt 1973 · S/N 1176N4698Hershey Flying Service Inc · David City, NES/N 1081N4728Porter Flying Service Inc · Chico, CAS/N 1089N4757Double D Flying Service Inc · Leesburg, GABuilt 1973 · S/N 1091N48374Ag Cat Applicators LLC · Avoca, TXBuilt 1976 · S/N 1619N48377Ag Spraying LLC · Bonner Springs, KSBuilt 1975 · S/N 1541N48383Jones James M Jr · Monroe, LABuilt 1976 · S/N 1623N48402Jones Ken · Grenada, MSBuilt 1976 · S/N 1630N48403Nielsen Richard D · Crystal Beach, TXBuilt 1976 · S/N 1631N48405Northwood Aero Service · Northwood, NDS/N 1632N48442Mid Continent Aircraft Corp · Hayti, MOBuilt 1976 · S/N 1646N48468Tumbleweed Leasing LLC · Tacoma, WABuilt 1976 · S/N 1649N48473Palouse Ag Leasing LLC · Moscow, IDBuilt 1976 · S/N 1654N48489Price William B · Lamar, SCBuilt 1976 · S/N 1651N48491Hartwig Lonnie · Edgeley, NDBuilt 1976 · S/N 1653N48524Mamuzich Robert J DBA · Deming, NMBuilt 1976 · S/N 1661N48555Milnor Agair Inc · Milnor, NDBuilt 1976 · S/N 1671N48556Lewis Flying & Maintenance Service · Morse, LABuilt 1976 · S/N 1638N48575Registered aircraftBuilt 1976 · S/N 1672N48582Triple F Flying Inc · Benton, PABuilt 1976 · S/N 1674N48613Crop-Aid Aerial Service LLC · Hillsboro, OHBuilt 1976 · S/N 1682N4863Eagle Air Service LLC · Greenfield, INBuilt 1972 · S/N 1016N48635Ag Aviation Service Inc · Elkhorn, WIBuilt 1976 · S/N 1684N50626Sale Reported · Austin, TXSale reportedBuilt 1975 · S/N 1511N5083Kramr David · Eagle Lake, TXBuilt 1973 · S/N 1115N5149Rock Creek Leasing LLC · Sapulpa, OKBuilt 1973 · S/N 1123N5236Porter Flying Service Inc · Chico, CAS/N 1130N5249Petersen Conrad H · Kenmare, NDBuilt 1973 · S/N 1131N5272Lanier John L Jr · Madison, ALS/N 652N5275Flying D Farm Inc · Kerhonkson, NYS/N 561N5279Vanderwaal Shane J · Junction City, WIBuilt 1968 · S/N 564N5286Slikker Flying Service Inc · Buttonwillow, CABuilt 1968 · S/N 562N5291Sky Aviation Corp · Worland, WYBuilt 1968 · S/N 572
Back to AD 72-02-02