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.
N31VXGordon Charles M Trustee · Haymarket, VAN31WBBaker James P · Brighton, CON31WFTaylor Peter L · Beaumont, TXN31WGFleischman James H · Remus, MIN31WKKing Wesley A · Los Angeles, CAN31WLAircraft Guaranty Corp Trustee · Oklahoma City, OKN31WM3 Point Aviation LLC · Claremont, NHN31WTThomas Norman W · Forest, VAN31WYBellamy Mark A · Freeville, NYN31XEverson Dustin J · Providence, RIN31YBritton Stephen D · Delhi, LAN31YBProgressive Air Inc · Janesville, WIN31YFCharliefoxtrot LLC · Farmington, MON31YKJendair LLC · New York, NYN31ZRRusso R Michael · Pipersville, PAN32003Gem Aviation Corp · Sugar Land, TXN32004Priceless Pleasures LLC · Jordan, MNN32008K L M Aircraft Co · Media, PAN3200ERegistration Pending · Burlington, WIRegistration pendingN3200GSpinner Family Limited Partnership · White City, ORN3200LRapid Imaging Solutions LLC · American Fork, UTN3200MPride Jesse D · Eagle River, AKN3200NLazy Bones LLC · Mitchell, SDN3200RTexeira David A · Venice, FLN3200SGreene James · Georgetown, TXN3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VAN3200WBrickley Brian J · Manchester, MIN3200YCondo Gerardo B · Miami, FLN3200ZBrady Michael E · Buffalo, NYN32019Spicher Samuel Charles · Harrisonburg, VAN3201DMelnick Victor D · Mount Bethel, PAN3201GArdent Aviation LLC · Salt Lake City, UTN3201LFowler Scott A · Lakeland, FLN3201SBoder Eric T · Knoxville, TNN3201ZMcclain William J · Corona, CAN32020N32020 LLC · Springfield, MON32025Biafora Joseph R Jr · Panorama City, CAN3202CJohnson Jeremiah · Fairbanks, AKN3202SCramer Traci · Hatfield, PAN32030Robert Starr · Schofield, WIN3203FChampagne Anthony J · Prairieville, LAN3203GAlpine Air Alaska LLC · Girdwood, AKN3203MDavid Dorin A · Kasilof, AKN3203UKuykendall Kirk O · Lakeside, ORN32042Van Anda Aviation LLC · Apopka, FLN32043Brolan Aviation LLC · Kansas City, MON32047Sat Aircraft LLC · Clermont, FLN3204DGriffith Sherman · Southlake, TXN3204UBlue Sky Flyers Inc · Punta Gorda, FLN32052Risley Bryan D · Bartow, FL
Back to AD 2007-04-19 R1