AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N334RDWrob Aero LLC · Del Rio, TXN334RLButters Brewster S · Port Orange, FLN334RTHyde Alfred D III · Denton, TXN334RVFlyrs Field Inc · Anchorage, AKN334SASchaumburg Flying Club Nfp · Palatine, ILN334SCGist Sally R · Horseshoe Bay, TXN334SESteeb Erik · San Luis Obispo, CAN334SPSierra Pop Air LLC · Wilmington, DEN334TFlying Crown Aviation LLC · Fond Du Lac, WIN334TRNachtigal Michael P · Ozark, MON334TXMagic Mentor LLC · Canyon, TXN334UWalter Matthew Timothy · Bella Vista, ARN334VHFly Fly Fly LLC · Dover, DEN334WCenturion Investments Inc DBA · Chesterfield, MON334WCFarmland Developers LLC · Jonesboro, ARN334WDSouthwest Aviation Enterprises · Haslet, TXN334WSCoolidge Oliver B Trustee · Denver, CON334YWarner Aric D · Rosamond, CAN3350FStrait Daniel · Sierra Vista, AZN3350SBarry Jason J · Orange, CAN3350TBaxley Aviation LLC · Baxley, GAN3350UKragseth Kyle A · Shoshone, IDN3350ZKintner Daniel S · Conyers, GAN33511Annis Aviation LLC · Gray, GAN3351LGagnon Philip F · Anchorage, AKN3351STarantino Nicholas T Jr · Union City, CAN3351TTaylor Gail L · Red Bluff, CAN3351WRegistered aircraftN3351XRuther Dennis A · Lake Havasu City, AZFirst renewal noticeN33520Dolbeare Eric E · Nebo, ILN33529Moon Scott R · Plover, WIN3352BRey Aviation LLC · Weston, FLN3352FDaradici Jodi A · Gilbert, AZN3352ZLoppnow Martin L · Yermo, CAN33530Lapointe Curtiss James · Powell, TNN33532Williams Kevin · Irvington, ALN33534Two One Aviation LLC · Benton, PAN3353PHeffron Jacob L · Little Falls, MNN3353TDwinell Jeffrey C · Granby, MAN3353UWieser Ranch Inc · Vernon, CON3353WGrigg Charles I Jr Trustee · Emporia, VAN3353XBain Jonathan · Newark, DEN33542Schmidt David L · Wasilla, AKN33545Beck Brady P · Nixon, TXN3354QOn The Beam Aviation Inc · Hampton, GAN3354WArocho David · Orlando, FLN3354XVirginia Aircraft Rentals LLC · Broadway, VAN3354YFelkins Roger C · Hillsboro, ALN3354ZJohnson Charles D · Benson, AZN33550Nutmeg Flying Club · Stratford, CT
Back to AD 2007-04-19 R1