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.
N202NDNorth Dakota Department Of Transportation · Bismarck, NDN203DHGuardian Flight LLC · Lewisville, TXFirst renewal noticeN203PCEaton Brothers Transportation LLC · Riverside, MON203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKN204JTBarbaro Enterprises LLC · Argyle, TXN204MBGreen Top LLC · Reidsville, GAN204WState Of Wisconsin · Madison, WIN2050ATia Aeronautics Inc · Harlingen, TXN205EJLynch Flying Service Inc DBA · Billings, MTN205MSJustice Air Inc · Farmingdale, NYN205SPState Of Colorado · Englewood, CON205STPate & Pate Air LLC · Andalusia, ALN205TMSmitty'S Supply Inc · Roseland, LAN207HBState Of Washington · Olympia, WAN207PDale Aviation · Rapid City, SDN20ERN20er LLC · Snellville, GAN20EWTriple H Aviation LLC · Milton, WVN20FDGilmer Aircraft Leasing LLC · Wilmington, DEN20SA Paradise Repo LLC · Nokomis, FLN20WPMoser Aircraft Service LLC · Huntington, INN210ECState Of Tennessee · Nashville, TNN210EXUnited States Navy · Patuxent River, MDN2112VRegistered aircraftN211CGAzul Air LLC · Dover, DEN211LGStaggerwing Holdings LLC · Englewood, CON212HCHcc Air LLC · Las Vegas, NVN212LWPf Aviation LLC · Carl Junction, MON213DBMarshall Air Systems Inc · Charlotte, NCN213MCMcr Aviation LLC · Austin, TXN214GBPterodactyl Inc · Wilmington, DEN214ML1st Franklin Financial Corp · Toccoa, GAN214PNavajo Nation · Window Rock, AZN214SBSan Bernardino Co Sherriffs Dept · San Bernardino, CAN214SCAzul Air LLC · Dover, DEN214TPPlatinum Aviation LLC · Monte Sereno, CAN215HCPlane Lease Co · Minneapolis, MNN217LGStaggerwing Holdings LLC · Crystal Lake, ILN217USDavis Aviation Inc · Brandon, MSN218DZRed Brick Summit LLC · Wilmington, DEN218GJJaztec LLC · Ooltewah, TNN218QDepartment Of Homeland Security · Washington, DCN2192LSiller Brothers Incorporated · Yuba City, CAN219BSG Force Air LLC · Las Vegas, NVN219JGInternational Jet Aviation Services Inc · Centennial, CON21BDSouthern Illinois Helicopters LLC · Marion, ILN21CGN21cg Leasing LLC · Ponca City, OKN21DZBravo Hotel LLC · Lewes, DEFirst renewal noticeN21KGSuncrest Aviation LLC · Labelle, FLN21RFN21rf LLC · Saint Louis, MON220CGOffshore Energy Services Inc · New Iberia, LA
Back to AD 98-15-13