AD 2001-08-08
Registered aircraft · 5,765
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:2001-08-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-08')
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:2001-08-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-08') 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.
N138TWSulka Andrew Mark · Pittsburgh, PAN1396AEsser J Randolph Trustee · Birmingham, ALN139ROlsen David A · Marinette, WIN139TATell Christopher A · Colville, WAN13BLCross Country Aviation LLC · Park City, UTN13EJAvidash LLC · Cape Coral, FLN13RKSwartz Charles Harris Jr · Spicewood, TXN13VMAhs Aero LLC · Phoenix, AZN13YZCreative Destination Development LLC · Mount Pleasant, TXN13ZZTigerair Of Alabama Inc · Newark, DEN140NLN140nl LLC · Maumelle, ARN1417BDavis Brad Michael · Whitesboro, TXN141HPBrankin Enterprises Inc · Dover, DEN141TWHunt Bradley · Wichita Falls, TXN141WSCopper Spike Aero LLC · Douglas, WYN142HGN142hg LLC · Manhasset, NYN1437AWashington Adrian P · Palm Harbor, FLN143KPescitelli Paul · Atlanta, GAN144AAllen Engineering · San Bernardino, CAN144KPrescott Medical Relief Services LLC · Prescott, AZN144PTHill Howard H Trustee · Portage, WIN144RExtrivo Inc · Lewes, DEN144SBPeters Aircraft Sales Flp · Wshngtn Ct Hs, OHN144TDDahlberg Thomas K · Belvidere, ILN1450BBerry Boger Yacht Sales Inc · North Myrtle Beach, SCN145JMA&K Aviation LLC · Lambertville, MIN145MTilley Steven E · Biddeford, MEN145TSBonanza A36 LLC · Wildwood, MON146BPNoughton Larry W · Fort Myers, FLN147DTGabriella Elena Inc · Winnetka, ILN147PN147p LLC · Wilkesboro, NCN147PWBarr Tammy D · Spicewood, TXN147UMartin Delano R · Spring, TXN148PRJaspar Dorsey E · Bakersfield, CAN148UUpmeyer Matthew D · Richland, WAN149BDLewellyn Jim · Bloomsburg, PAN149GMetro Flyers Ltd · N Richland Hills, TXN149RBest Erectors Inc · Wilmington, DEN149WLCarter Robert J Jr · Oak Ridge, TNN14ARRatliff Alvin · Northport, ALN14CMGallagher Michael S · Los Alamitos, CAN14FMDurbin Gregory M · Dallas, TXN14JPDakota Aircraft Inc · Pierre, SDN14LRGolly Laura · Deridder, LAN14MBJackson Craig D · Idaho Falls, IDN14MNOne Room LLC · Abilene, TXN14RFBerry Darrel · Camden, TNN14WWWa Consulting LLC · Nashville, TNN1500BElectrical Field Services Inc · Huffman, TXN1500FGerhold Jeremy · Rosharon, TX
Back to AD 2001-08-08