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.
N387ATAirtrex Aircraft November Inc · Wichita, KSN387SCHeritage Aviation Management Ltd · Conroe, TXN388KFKiernan Companies LLC · Englewood, CON389DDAircraft Guaranty Corp Trustee · Oklahoma City, OKN389RAAirtrex Aircraft Xray Inc · Wichita, KSN38APClear Canyon I LLC · Amarillo, TXN38JVKcsi Aerial Patrol Inc · Bakersfield, CAN38VSNv5 Geospatial Inc · Sheboygan Falls, WIN390PSMcm Holdings Inc · Lincoln, NEN390SPState Of Arkansas · Little Rock, ARN390SRBenchmark 350 LLC · Plano, TXN391GFEverbank Na · Chicago, ILN391HCFly-Area LLC · Charleston, SCN392CAInternational Air Services Inc Trustee · Carson City, NVN392GFEverbank Na · Chicago, ILN393GFEverbank Na · Chicago, ILN394ALTeebird Enterprises LLC · Brighton, COFirst renewal noticeN394GFEverbank Na · Chicago, ILN395AAAdvanced Air LLC · Hawthorne, CAN395ABFr Air LLC · Palm Harbor, FLN395AMHollan Air LLC · Amarillo, TXN395AVAdvanced Air LLC · Hawthorne, CAN395CFCsc Delaware Trust Co Trustee · Wilmington, DEN395GFEverbank Na · Chicago, ILN395MBAdvanced Air LLC · Hawthorne, CAN395RCHealdsburg Red Car Partners LLC · Pacific Palisades, CAN395TGWhite Crow Air LLC · San Luis Obispo, CAN396FSAircraft Trust & Financing Corp Trustee · Wilmington, DEN396GFEverbank Na · Chicago, ILN396MFRango Aviation LLC · Mesa, AZN397GFEverbank Na · Chicago, ILN398GFEverbank Na · Chicago, ILN399ALBallard Aviation Inc · Newton, KSN399TWArx Air LLC · Windermere, FLN399WSGuardian Flight LLC · Lewisville, TXN39FBButler National Inc · New Century, KSN39MZTiger Takeoff LLC · Columbia, MON3AHEat Veggies 3 LLC · Savannah, GAN3AWArrowhead Burbank Inc · Burbank, OKN3BAConstruction Enterprises Inc · Franklin, TNN3DFTaurman Keith L · Virginia Beach, VAN3GCTexas Air & Space Museum · Amarillo, TXN3LSConcept Management Company LLC · Spartanburg, SCN3MEAero F90 LLC · Oxnard, CAN3MFJ & K Aviation Inc · Conway, ARN3MHN3mh LLC · Kalispell, MTN3NCNorth Carolina Dept Transportation · Raleigh, NCN3PXAirtime LLC · Mont Belvieu, TXN3XBMonument Aviation LLC · North Chesterfield, VAN400AYVann Air Investments LLC · Williams, CA
Back to AD 98-15-13