AD 2016-01-01
Registered aircraft · 412
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:2016-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-01-01')
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:2016-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-01-01') 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.
N65PVRhrsc LLC · Tucson, AZN668KCJohn A Lester LLC · Union City, TNN675MAOwyhee Produce LLC · Parma, IDN675RCSparrow Holdings LLC · Hawley, MNN676MADlc Aviation Inc Trustee · Wilmington, DEN678ABHeart Rhythm Center Of Mississippi LLC · Flowood, MSN67BWHarvey Robert B Jr · Fort Worth, TXN681RVDelaware Aircraft Trust LLC Trustee · New Castle, DEN684KMSky West Aviation Inc Trustee · Albuquerque, NMN698ATNugent Inc · Indianapolis, INN700BGSuisse Management LLC · Park City, UTN705MAJ K Air LLC · Columbus, INN706PMGizmo Aviation LLC · Roswell, NMN711SBCashsouth LLC · Georgetown, DEN713WATempus Fugit LLC · Henderson, CON71RDRagincajun Aviation LLC · Missoula, MTN720FGClark Charles · Basking Ridge, NJN721MTThesman One Investments LLC · Las Vegas, NVN723KGcn Investments LLC · Hastings, NEN724HAPriori Holdings Inc · Jacksonville, FLN726WAWestern Aircraft Inc · Boise, IDN72CBFlatland Aviation LLC · Aberdeen, SDN72WYBas Part Sales LLC · Greeley, CON731BRPiper Aircraft Inc · Vero Beach, FLN731JBLea Kenneth R Trustee · St Charles, ILN731VGCoastal Meridian LLC · El Segundo, CAFirst renewal noticeN733PBw69 Air LLC · Fort Walton Beach, FLN73VKBsnt LLC · Mooresville, NCN747XTEp747xt LLC · Miamisburg, OHN752MMMc Aviation LLC · Fort Lauderdale, FLN753CGaviota Holdings LLC · Goleta, CAN759HPerfect Solutions Inc · Elma, NYN767TPNuage Holdings LLC · Sioux Falls, SDN76KJA&D Terminal Management LLC · Towaco, NJN76MGCook Brothers Farms LLC · Princeton, KYN76VBPiper Aircraft Inc · Vero Beach, FLN77400Pettit Brian · Wshngtn Ct Hs, OHN777MGSe Aviation LLC · Champlin, MNN77BTWings Up LLC · Kansas City, MON77VFOrions Victor Foxtrot LLC · Truckee, CAN7818MFlynn Bec Gp Inc · Spokane, WAN7873CFlying Goat LLC · San Diego, CAN795FApplegarth Investment Co LLC · Kentfield, CAN796JDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7UJMad Logging LLC · Sturgeon, MON802MMAuburn Air Leasing LLC · Kalispell, MTN804JHRocky Mountain Boat Co · Pueblo West, CON808LASouth Bound Holdings LLC · Knoxville, TNN815CFMeridian Air LLC · New Boston, MIN816BCAv8me LLC · Spicewood, TX
Back to AD 2016-01-01