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.
N243PBFargo Jet Center LLC · Fargo, NDN244HAHowell Air LLC · Dover, DEN246AAAir Services International Leasing LLC · Fort Lauderdale, FLN246CKMccarty David M · Baker City, ORN246GTWestern Pilot Service Inc · Phoenix, AZN246PHPhi Health LLC · Tempe, AZN247CHShe Jane LLC · Laguna Beach, CAN247MDLta Group Holdings LLC · Amarillo, TXN247SZSheetz Aviation Inc · Altoona, PAN248EXUnited States Navy · Patuxent River, MDN248JHExecutive King Air Transportation Inc · Wilmington, DEN248PHPhi Health LLC · Tempe, AZN249CPAngels Envy Aviation LLC · Denison, TXN249WM249 Aviation LLC · Richland, MSN24AWalker John D · Neosho, MON24BGVarney Aviation LLC · Bangor, MEN24EMAsphalt Aviation LLC · Conway, SCN24GNGlobal Air Concepts LLC · Anchorage, AKN24JDVac Sys Holdings LLC · Roseville, CAN250AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN250FCKorban Aviation LLC · Mcallen, TXFirst renewal noticeN250LHAl Air LLC · Knoxville, TNN250TTLakeside Metal Specialties Inc · Paragould, ARN250WGChartco LLC · Salisbury, NCN251CFN251cf LLC · Dove Canyon, CAN251JDepartment Of Homeland Security · Washington, DCN252FLTenax Aerospace LLC · Ridgeland, MSN252HRJohnson Breeders Inc · Rose Hill, NCN252RCPrestige Worldwide Flights Two LLC · Imperial, CAN254PCAtlantic Wings LLC · New Bern, NCN255BBWright Aviation LLC · Charleston, TNN255TTTrident Aircraft Holdings LLC · Nashville, TNN259SCCei Inc · Wilmington, DEN25GRBarrosa LLC · Scottsbluff, NEN25WCMau Leasing LLC · Newark, DEN260TTTri-State Generation & Transmission Association · Westminster, CON261GBSafford Aviation Service Inc · Coolidge, AZN261MAMajestic Aviation LLC · Decatur, ALN262SPAluminum Eagle LLC · South Jordan, UTN263BACreative Life LLC · St Pete Beach, FLN264PARisk Assumption LLC · Horseshoe Bay, TXN264TSFoxtrot Aviation Services LLC · Canton, OHN266RDGuardian Flight LLC · Lewisville, TXN267COldham Matthew Stephen · Lewisville, TXFirst renewal noticeN268CACaruthers LLC · Moundville, ALN268LBLark Builders · Vidalia, GAN26ARDale Aviation · Rapid City, SDN26EDynamic Avlease Inc · Bridgewater, VAN26PYColibri26 Inc Trustee · Wilmington, DEN26RERrr Aviation LLC · Gulfport, MS
Back to AD 98-15-13