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.
N1228PPapa Aviation LLC · Chicago, ILN122CERay Kevin T · Columbus, TXN122GTSperr Adam C · Donnelly, MNN122LGStewart John H · Burlington, CON122SNKinsey Timothy James · La Grange, TXN122TWJmi Associates LLC · Wilmington, DEN1230ZC & J Air Inc · Middleton, DEN1234QDembowski Rodrick · Seattle, WAN1234TBonanza LLC · Huntington, WVN1234VFrailey Randy J · Chouteau, OKN1235CWerner Christopher Wayne · Fayetteville, GAN123AVGc 43 LLC · Annandale, VAN123CTPastor Jordan D · Riverside, CAN123ECJohnson Howard A · Lake Forest Park, WAN123GSLou Ann Inc · Los Altos, CAN123MMMuller Miles O · Staples, TXN123RGChurch Brett L · Whitefish, MTN123RKPlane Fun Inc Tr Trustee · Snellville, GAN123TWGrandy Boyd · Smoot, WYN1240AAlfa Monkey LLC · Wolfforth, TXN124DRendezvous Island Air LLC · Fort Collins, CON124LCBucks Air Charters Inc · Wilmington, DEN1259ML A M Capital Management LLC · Sheridan, WYN125PCRegistered aircraftN125TR Darrell Weaver Enterprises LLC · Moore, OKN126GLN126gl LLC · Roca, NEN126HBockman Ltd · Milford, IAN126WGN126wg LLC · Oak Brook, ILN1273SSullivan Stephen G · Mize, MSN128AEChiave Solutions LLC · Orlando, FLN128WMOac Aviation LLC · Asheville, NCN1296AN1296a LLC · Asheville, NCN129BMMain Gary Michael · Haverford, PAN129EEBuntings Grassroots Aviation LLC · Selbyville, DEN129RJKenney Donill · Lake Worth, FLN129TRDawson Aircraft Inc · Clinton, ARN129XSwarts Robert · Cincinnati, OHN12AVChambers Richard A · Sandpoint, IDFirst renewal noticeN12BTexacali Air LLC · Salado, TXN12EMMcneill Matthew C · Phoenix, AZN12FGEchols Mill Aviation LLC · Elberton, GAN12GBOliver Jonathan F Sr · Waxahachie, TXN12KCHeath David A Trustee · Cottonwood, AZN12PMFlying Bald Eagles Inc · New Lenox, ILN12RCSkipper Thomas · Coburg, ORN1313WSecond Kitchen LLC · Chicago, ILN1316RAirgo Partners LLC · Lititz, PAN131DDLife Investors Aviation LLC · Milwaukee, WIN132FBRock Rivers Bancorp · Rock Rapids, IAN133AGRaritan Valley Flying School · Princeton, NJ
Back to AD 2001-08-08