AD 98-05-14 R1
Registered aircraft · 909
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:98-05-14-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:98-05-14-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:98-05-14-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:98-05-14-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.
N210RBLibrary Interiors Of Florida Inc · Auburndale, FLN210RDPlane Fun Inc Tr Trustee · Snellville, GAN210REValiair Lc Trustee · Casper, WYN210RPRegistration Pending · Charlestown, INRegistration pendingN210RSInternational Air Services Inc Trustee · Carson City, NVN210SDArdoin Robin C · Lafayette, LAN210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN210SLKenmore Crew Leasing Inc Trustee · Bellingham, WAN210SMMcconnell Peter · Valencia, PAN210SNDominguez Mark J · Many, LAN210SSVucich Bryant · Palm Beach Gardens, FLN210TGDouble H Enterprises LLC · Bolivar, MON210TJJaco Oil Company · Bakersfield, CAN210TPAirborne Enterprises LLC · Ava, MON210TSGeary Inc · Westcliffe, CON210TYRiley Charles · Littleton, CON210VBHoogendyk Robert · Big Bear City, CAN210VJV J Wings Inc · Wilmington, DEN210VTStricker Andreas Daniel · Essex Junction, VTN210VVHeesacker Stephen L Trustee · Los Altos, CAN210WCWeeks Curtis E · Cotulla, TXN210WJRude Daniel · Leesburg, VAN210WWInternational Air Services Inc Trustee · Carson City, NVN211CFGoudreau Sean · Mount Dora, FLN211LR & G Schatz Farms Inc · Lockeford, CAN212SBSycamore Partners LLC · Johnson, ARN212TSParkside Automotive & Truck Service · Mountain Top, PAN212WKRbm Adventures LLC · Jamestown, NYN2134UDean Steel Buildings Inc · Fort Myers, FLN21492Puryear Rodney K · Pampa, TXN214MKoo C Carlos · Atherton, CAN215GNBbt Jewelry LLC · Miami, FLN218CCSotally Tober LLC · Wilmington, DEN21BESpecialized Helicopter Training LLC · Middleton, IDN21CTFerreira Douglas B Trustee · Chico, CAN21KRNorcon Enterprises Inc · Amarillo, TXN21LTMission Flight · El Monte, CAN220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYN220TJJaco Oil Co · Bakersfield, CAN222ETValiair Lc Trustee · Casper, WYN222SGPacific Aviation Aircraft Management Inc · Fresno, CAN224KAChambers William Melvin Jr · Azle, TXN224MHFeely Daniel R · Pasadena, CAN224PKValiair Lc Trustee · Casper, WYN22VFAir Conejos LLC · El Paso, TXN22WGCorpat Inc · Missoula, MTN2306DUS Navy - Owner · Jacksonville, FLN231PTLobbytools Aviation LLC · Friday Harbor, WAN2340UTex-Pan Aviation Inc · Amarillo, TXN234BWWaring Marvin Barton · Anacortes, WA
Back to AD 98-05-14 R1