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.
N3857TAmt Services LLC · Virginia Beach, VAN3857YLutz Matthew B · Jackson, TNN3857ZKnutson Wayne R · Tioga, NDN38580Avier LLC · Beverly, MAN38587Swihart Painting LLC · Bolivar, MON3858MMachias Auto Parts Inc · Jonesport, MEN3858QPylant Eric Jon · Arnold, CAN3858RBaugh David · Kirkland, WAN3858TFlying Dots LLC · Daytona Beach, FLN3858ZGreat Basin Aviation LLC · Eagle River, AKN3859CSweet Phillips R · Laguna Beach, CAN3859MWhite Roger L · Wallins Creek, KYN3859NWilson Bryan J · Henderson, NCN3859TYurek Allen L · Fairfax, VAN3859WFast Lane Aviation Lllp · Hawkinsville, GAFirst renewal noticeN3859YMorse Donald W · Priest Lake, IDFirst renewal noticeN3859ZBarnes Welding Inc · Waterville, WAN385ASCoraggio Joe · Chandler, AZN385BRust Jeffrey J · San Antonio, TXN385BCRobinson Eric C · Palmer, AKN385BFGriffith Jonathan E · Newark, NJN385CFoster Harry A · Birmingham, ALN385CAHyannis Air Service Inc · Hyannis, MAN385CCCharlie Charlie Inc · Chimacum, WAN385CMCoastal Elite Air LLC · Helena, MTN385DProfessional Training Aircraft LLC · Wilmington, DEN385DCDyncorp International Inc · Mcclellan, CAN385GRegistered aircraftN385JBBeck Todd G · Clarkston, MIN385KLIasco Flight Training Inc · Redding, CAN385MAPesek Larry Paul · Steinhatchee, FLN385RAdvanced Technology Distributors Inc · Ceres, CAN385RBNational Aircraft Leasing Corp · Greenville, DEN385SCHogan William J · Libby, MTN385SPAircraft Trustee Services Inc Trustee · Dover, DEN385TEBowers Nick · Mount Hope, WIN385TWSheely Patrick D Trustee · Rapid City, SDN385WWeixler Ronald A · Salt Lake City, UTN385XJohns Justin C · Dillingham, AKN38603Flight Share LLC · Charlotte, NCN38605Registration Pending · Kalispell, MTRegistration pendingN3860RLundgren Christopher B · Graham, TXN3860TTds Property Holdings LLC · Gilmer, TXN3860VAts LLC · Memphis, TNN3860WBrasfield Jason · Bonnerdale, ARN3860XOverall Aviators LLC · Parsons, KSN3860ZKrueger Robert C · Glenburn, MEN3861CBuben Michael · Chandler, AZN3861NZekic Zivojin · Austin, TXN3861PDellinger Jeremiah · Eagle River, AK
Back to AD 2007-04-19 R1