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.
N26RFVuc Inc · Allentown, PAN2702SMdm Air LLC · Belpre, OHN270MNardi Greg P · Missoula, MTN274KARgv Sky LLC · Harlingen, TXN275LARts Ventures LLC · San Antonio, TXN275LLN275ll LLC · Wilmington, DEN276EBMountain Air Aviation LLC · Jonesville, VAN276JBChris Allen Aviation LLC · Naples, FLN277FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN277GERltwf LLC · Fiddletown, CAN277GLDiamondback Equipment Leasing LLC · Avondale, AZN277JEAir LLC · Jasper, INN277JJHjjv LLC · Walterboro, SCN277SPAll Systems Satellite Distributors Of Delaware LLC · Newark, DEN278KWAir Rgv LLC · Mcallen, TXN278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN27BNTravelaire Service Inc · Wilmington, DEN27RCCoastal Holding LLC · Holland, MIN280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXN280WDWak Aviations LLC · Green Bay, WIN282AMRfp Enterprises Inc · Bridge City, TXN282DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN283JDDurham Aircraft LLC · Port Aransas, TXN284MRDale Aviation Inc · Rapid City, SDN284PMArtic Legacy Aviation LLC · Anchorage, AKN285RRio Bank · Mcallen, TXN285RBButler National Inc · New Century, KSN287ATN399bw LLC · California, MDN288ATN38ry LLC · California, MDN288KMGarmin International Inc · Olathe, KSN289ATN999mg LLC · California, MDN28BDSouthern Illinois Helicopters LLC · Marion, ILN28ELDodson International Parts Inc · Rantoul, KSN28KAJames John · Bennett, CON28KMN28km LLC · Wilmington, NCN28KPState Of Montana · Helena, MTN28VRPajaro 195 LLC · Fort Worth, TXN28WCMoorad Sports Partners LLC · Newport Beach, CAN290CCMonument Aviation LLC · North Chesterfield, VAN290KAir Ems Inc · Tulsa, OKN290KAN290ka LLC · Clare, MIN290NCMr Boo Properties LLC · Indianapolis, INN290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYN291ASLasai Aviation LLC · Reston, VAN291CCMobile Ehr Inc · Argyle, TXN291DFRmb Leasing Inc · Dover, DEN292APlacebo Air LLC · Ridgecrest, CAN292TGCrown Aviation LLC · Lawrence, KSN294TTUncommon Solutions LLC · Hollis, NHN295DCHibiscus26 Inc Trustee · Wilmington, DE
Back to AD 98-15-13