AD 98-15-13
Registered aircraft · 2,358
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-15-13')
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-15-13')
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-15-13') 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-15-13') 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.
N177LACabeza De Vaca Holdings LLC · Carrollton, TXN177MKTrans Equipment Svcs Inc · Greenville, SCN178LAPonca International LLC · Bentonville, ARN179MDGem City Properties LLC · Laramie, WYN179WBShaken Aviation LLC · Madison, ALN17CELdc Air LLC · Rochester, NYN17EHSystem Packaging Co Inc · Bell, CAN17GGJ Aviation LLC · Boca Raton, FLN17KKRiverbend Aviation LLC · Hernando, MSN17NMCentral Virginia Aviation Inc · Petersburg, VAN17WCHm Aviation Holdings LLC · Fort Pierce, FLN17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN17YLYowell Legacy Aviation LLC · Killeen, TXN1801BSjd Flight LLC · Houston, TXN182CASky West Aviation Inc Trustee · Albuquerque, NMN183SADriscoll David A · Savannah, TNN18471Chase Air LLC · Montgomery, ALN1848ST&T Air LLC · Lindsay, OKN184DNorth Country Holdings LLC · Moses Lake, WAN184TXZms Aviation LLC · Wilmington, DEN1857F56 Express LLC · Willmar, MNN185MVSouthwest Aviation Inc Div · Marshall, MNN1867State Of Alaska · Anchorage, AKN187ALAlm Holdings Delaware 2 LLC · Wilmington, DEN187VDepartment Of Homeland Security · Washington, DCN188KAErostar LLC · Wilmington, NCN188LLTriple Aviation LLC · San Leon, TXN189ALAlm Holdings Delaware 4 LLC · Wilmington, DEN189MDCae III Ltd · Wilmington, DEN18AFN220pb LLC · Mesa, AZN18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeN18MYWorld Aircraft Leasing Inc · Wilmington, DEFirst renewal noticeN18SFD&D Maintenance LLC · Etna Green, INN190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN190BHJourney Aviation LLC · Brookland, ARN190EBKar King LLC · Huntington, WVN190EFTriple E Farms LLC · Pasco, WAN190FDOreh Aircraft LLC · New Braunfels, TXN190JPClearwater Midstream LLC · Lubbock, TXN190NCCf Holdings LLC · Hernando, MSN190RLCamair Leasing LLC · Granbury, TXN190SSJ&H Kramer Inc · Redwood City, CAN190TTAcme Jet LLC · Dover, DEN190XTNextant Aerospace LLC · Cleveland, OHN191JRLocke-Lane Aviation LLC · Statesville, NCN1923TTvpx Ars Inc Trustee · North Salt Lake, UTN192FDepartment Of Homeland Security · Washington, DCN193RAWilmington Trust Co Trustee · Wilmington, DEN194TRExecutive Air Taxi Corp · Bismarck, NDN194YYTj Air Holdings Inc Trustee · Wilmington, DE
Back to AD 98-15-13