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.
N120TMurphy Janet A · Stafford, KSN1210ACaneen Jeremy M · Wasilla, AKN1214ARegistered aircraftN1219AFeltman Joshua C · Kenai, AKN1221AGerbi Charles R Trustee · Auke Bay, AKN1222ADawley Creek Ranch Nv LLC · Ruby Valley, NVN1226AWalsh Brendan · Seattle, WAN122BEBarton Preston S · San Antonio, TXN122TCarraher Timothy J · Spalding, NEN1233ADecker Leon T · Hollister, CAN1238AArnold Joe R · Burns, ORN1244APickard Martha Anne Gabriel · Hudson, OHN1246Lablanc Michael T · Intl Falls, MNN1246AGay Ranch Inc · Broadus, MTN1248ABaugh Andrew Lawrence · Anchorage, AKN1249AAirmotive Service LLC · Brigham City, UTN124GSDetommaso James F · North Pole, AKN124TTappan East LLC · New Philadelphia, OHN1251APappas Timothy G · Big Lake, AKN1252CDavis Doyle M · Clancy, MTN1253ALange Keith J · Wasilla, AKN1258ALake Country Lodge Inc · Port Alsworth, AKN1258CSmith Samuel Richard · Seward, AKN1259AHigh Exposure Inc · Wilmington, DEN1259CBowers Michael · Chugiak, AKN125FGState Of Alaska · Kodiak, AKN1263AMurphy Janet A · Stafford, KSN1264APierskalla Nicolas B · Wasilla, AKN1265AWalker Matthew J Trustee · Delta Junction, AKN1268ATegerdine Charley D · Sterling, AKN126THentges Kelley R · Frazer, MTN1270ASnow Richard C · Wasilla, AKN1272AJacoby Peter A · Tucson, AZN1277AWagner Tyler M · Sitka, AKN1278ARegistration Pending · Palmer, AKRegistration pendingN127TBenham Charles · Lorena, TXN1283AFritz David A · Wasilla, AKN1291ASeale Sidney Joseph · Condon, ORN1291CVand Flyve Klub · Newfolden, MNN1294AHubbard John H · Riverside, WAN1295AJenski Kobie · Sutton, AKN1297AOrwick Robert J · Newell, SDN1304ABilben Steve W · Kasilof, AKN1305AAir Dakota Flite Inc · Hettinger, NDN1312ABowen Haldor S · Sandpoint, IDN1314AK & D Livestock Inc · Volborg, MTN1317ADixon Douglas C · Anchorage, AKN1320ATerra Firma Aviation LLC · Bowman, CAN1322AWrobel Sean M · Weatherford, TXN1324AJagow Charles P · Fairbanks, AK
Back to AD 72-01-07