AD 72-08-06
Registered aircraft · 10,639
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-08-06')
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-08-06')
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-08-06') 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-08-06') 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.
N1388TNora Jet LLC · Granbury, TXN1389TR And S Flying LLC · Westfield, MAN138SFUnderwood Mark A · Kennewick, WAN138TPTwo Pauls LLC · Forked River, NJN1391TAbita Air LLC · Covington, LAN139SNMccullough Jacob D · Lockhart, TXN13KFRockwood Blake T · Fort Worth, TXN13KRKaplan Ronald · Palm Beach Gardens, FLN13RGIsland Piper Llp · St Helena Is, SCN14033Nomadic Flight Training LLC · New Castle, DEN14060Skinner Daniel R · Mount Airy, GAN1407XRavotti Air LLC · Leechburg, PAN1408TCarter Jeff · Paragould, ARN1409TAnker Mark W · Cambridge, OHN1409XHolmberg Shane A · Fairbanks, AKN140ACApplebaugh Jeffrey · Mechanicsville, MDN140AMSuchko Paul S · Venetia, PAN140BCN504fl LLC · Killeen, TXN140BKFrauenhoffer Kenneth E · Woodruff, WIN140CKRegistered aircraftFirst renewal noticeN140DDBe Right Back Aviation LLC · Billings, MTN140FLYocum Stuart J · Kingman, AZN140GBReel Christen · Leighton, ALN140HACarros Dale A · Cape Charles, VAN140HCMurphy David B · Germantown, MDN140JFMeriden Aviation Center LLC · Meriden, CTN140JGBarros Vincent · Kissimmee, FLN140JNMfd Aviation Inc · Middletown, DEN140KW47 North Aviation LLC DBA · Wenatchee, WAN140LRutten Paul J · Pine Island, MNN140MDDesotel Mark · Fairfax, IAN140NCRamirez Jesus Nicolas · Miami, FLN140PLBennett Daniel C · Atlantic Beach, FLN140SBSkyfusion II LLC · Atlanta, GAN140SDG5 Services LLC · Myrtle Beach, SCN140SHThomas Raymond · Daytona Beach, FLN140SNRomey Shelley · Newnan, GAN140WMBlue Wings LLC · Rossville, TNN140ZGitomirski Michael L · Moseley, VAN1416TRegistered aircraftN1417TWood Andrew Calvin · Tallahassee, FLN1418TZucchi Steven · Ephrata, PAN1419XWhitman Aviation LLC · Morganville, NJN141ANWells Ryan · Holdrege, NEN141KRScanlon John (Jack) · Palos Heights, ILN141SWCouture Logan · Grand Forks, NDN1422XDt'S Aviation LLC · Garden City, KSN1423TWaggoner Kevin M · Donnellson, IAN1424MFly High LLC · Mobile, ALN1424TFoster Adam J · Houston, TX
Back to AD 72-08-06