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.
N33SBPittsburgh Institute Of Aeronautics · West Mifflin, PAN33WC17wc LLC · Santa Ana, CAN341WBAndrews Worldwide LLC · Amarillo, TXN341WETextron Aviation Inc · Wichita, KSN342ERSoutheast Aviation LLC · Oxford, MSN342KFTudor Leasing LLC · Hemlock, MIN343KKTreeline Transportation Inc · Vance, ALN345CKCklass Transport Inc · Chula Vista, CAN345DGRfp Enterprises Inc · Bridge City, TXN346BALwcr Transportation Inc · Minot, NDN349ARAcademy Resources LLC · Taos, NMN349CAMetrea Special Aerospace Isr Inc · Bethany, OKN34CEFirst Call Home Health Agency LLC · Salem, ORN34LTPaper Boys LLC · Dover, DEN34MFDavis Aviation Inc · Brandon, MSN34UPCentral Virginia Aviation Inc · Petersburg, VAN350ABGolden Eagle One LLC · Garden City, KSN350AEWcp Developers LLC · Clovis, CAN350AFTechnav LLC · Columbus, INN350ALBrownstone Aviation LLC · Houston, TXN350BBRtd Air LLC · Hernando, MSN350BDParrot Air LLC · Corpus Christi, TXN350BSKa Partners LLC · Thomson, GAN350BWWilmington Trust Co Trustee · Wilmington, DEN350BZLogistics Business Services LLC · Cheshire, CTN350CFClemens Aviation LLC · Wichita, KSN350DRDeroyal Industries Inc · Powell, TNN350ESAdvanced Air LLC · Hawthorne, CAN350FCModern Industrial Services Inc · Beaumont, TXN350FPHff Partners LLC · Fresno, CAN350FWAir Excursions LLC · Chicago, ILN350GACsc Delaware Trust Co Trustee · Wilmington, DEN350GLWipaire Inc · South Saint Paul, MNN350GRJuliet Bravo Inc · Austin, TXN350HCChildress Holdings LLC · Wilmington, DEN350JSouthern Star Inc · Poteau, OKN350JFJdf Equipment Sales LLC · Lynn Haven, FLN350JGBennie Air II LLC · Culbertson, NEN350JPCanton Aviation LLC · Canton, OHN350JWRegistration Pending · Middletown, DERegistration pendingN350KN350k LLC · Sacramento, CAN350KABigups Aviation 011 LLC · Van Nuys, CAN350KDHerr Daniel Rhyne · Murray Hill, NJN350KFTextron Aviation Inc · Wichita, KSN350KGTenax Air Logistics LLC · Ridgeland, MSN350KSSedgwick County · Wichita, KSN350KVWilmington Trust Co Trustee · Wilmington, DEN350MFayette Aviation LLC · Somerville, TNN350MCMayo Clinic · Rochester, MNN350MGRangeflyers Inc Trustee · Wichita, KS
Back to AD 98-15-13