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.
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
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.
N1325AAlaskas Cub Training Specialists LLC · Wasilla, AKN1329AWatsabaugh Byron D Jr · Gillette, WYN132LClapp William H · Mountain View, MON1330AKost George K L · Nome, AKN1331ACoffee Barry L · Auke Bay, AKN1334ABrowne Alfred A · Gardnerville, NVN1336APluhar Charles J · Cohagen, MTN133TTroftgruben Gregory G · Buxton, NDN1340A4031 Aviation Inc · Bemidji, MNN1342AHagenston Arthur J · Fairbanks, AKN1347AKalba Shaun B · Pleasant Valley, NYN1348AMiller Adam S · Bend, ORN1350CBryant Stephen C · Anchorage, AKN1352CBaker Mark R · Summerland Key, FLN1354CAklested William T · Palmer, AKN1355AStanton Fred H · Amherst, NYN1357ACarson Cubs LLC · Yelm, WAN1358ASchroeder Herbert P · Eagle River, AKN135KSBunde Konstantine E · Goldendale, WAN135RBWalter Caleb · Buffalo, WYN135WKGerlach Robert · Talkeetna, AKN135WMTownsend Richard A · Wasilla, AKN1363AHale Mitchell D · Chugiak, AKN1364AFranz Stanley · Yakima, WAN1365ARegistration Pending · Wasilla, AKRegistration pendingN1365CSchultz Kenneth W · Ekalaka, MTN1366AT & E Inc · Fowler, KSN1366CKuzina Ronald E · Wasilla, AKN1367ALl Wings LLC · Minnetonka, MNN1367CFerguson Bruce W · Fort Peck, MTN1368AMcknight Thomas N · Fredericksburg, TXN1372ABice Donald L · Winner, SDN1377AFar Horizon LLC · Bighorn, MTN1378ADray LLC · Bridgeport, NEN137TMonno Joseph P · Hastings, MNN1380AGlenn Douglas W · Palmer, AKN1385CBlake Hughie R · Cordova, AKN1386AState Of Alaska · Anchorage, AKN1387GList Martinus R · Wasilla, AKN1389AMorris David G · Wasilla, AKN1392AHerrig Daniel C · King Salmon, AKN1394RRoss Bill · Meridian, MSN1394YOjendyk Mark R · Newcastle, WAN1398AN1398a LLC · Anchorage, AKN13FFVeal Tim S · Kenai, AKN13RYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN141TRipley Jesse W · Wasilla, AKN142TReed Britt A · White Salmon, WAN14319Erickson Mark D · Valley Springs, SDN143TMurray Paul M Trustee · Storm Lake, IA
Back to AD 72-01-07