AD 2016-12-01
Registered aircraft · 1,377
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-12-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-12-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-12-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-12-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.
N283AFJ3b LLC · Portsmouth, NHN283CUShoreline Assets LLC · Medford, ORN283VCSunridge Aviation LLC · Henderson, NVN284GGtn Aviation LLC · Visalia, CAN2852NFrahm Aviation LLC · Colby, KSN285AGBank Of Utah Trustee · Salt Lake City, UTN285KTBlink Aviation LLC · Sioux Falls, SDN285NGTvpx Trust Co LLC Trustee · North Salt Lake, UTN285PBBank Of Utah Trustee · Salt Lake City, UTN285SAHidden Bluff Holdings LLC · Waco, TXN285SDDm Strategies Inc · Grosse Ile, MIN286NWSpur Aviation Services Lc · Twin Falls, IDN287PCBank Of Utah Trustee · Salt Lake City, UTN287WRPi Sn1754 LLC · Fort Lauderdale, FLN288AFMod-Pac Corp · Portsmouth, NHN288SEBig Wednesday Air LLC · Long Beach, CAN28KRValore Aviation LLC · Baton Rouge, LAN28NXDooalot Pc-12 LLC · New York, NYN290JKD7 Roofing LLC · New Baden, ILN291FTMauna Holdings LLC · Newark, DEN291KYValera LLC · Mayfield, KYN292PSteelman Aviation Inc · Las Vegas, NVN293TWBedford Partners LLC · Oxford, CTN294NGMjj Capital Management Inc · Ross, CAN298TTMat Air LLC · Bridgeport, TXN299AMAir Methods LLC · Greenwood Village, CON29BBPc-12 Kwru LLC · Stockton, CAN29BYKaisarion Air LLC · Ogden, UTN29BZFb Air LLC · Springfield, MNN29TUBank Of Utah Trustee · Salt Lake City, UTN300SMRykel Aviation LLC · Camden, DEN3020AMidatlantic Airtransport LLC · Rehoboth Beach, DEN302PBDoverdel LLC · Bensenville, ILN303JDLisgar II LLC · San Rafael, CAN304PTTrygg Holdings LLC · Anchorage, AKN306PCMar Aviation Corp · Boardman, OHN307TSAir Methods LLC · Greenwood Village, CON307WLJk&S Movers LLC · Winter Park, FLN307WPAg Transit LLC · Topeka, KSN308LMLandmark Implement Inc · Kearney, NEN311VMGuardian Flight LLC · Lewisville, TXN312BCWorldwide Option LLC · Lewes, DEN312GAGulfstream Leasing LLC · Savannah, GAN312PCPacific Real Estate Consulting LLC · Irvine, CAN312PMGretchen LLC · Boise, IDN313GXSilver Britches Air II LLC · Wilmington, DEN313NGPwc Aviation LLC · Omaha, NEN315NGIntermountain Medical Transport LLC · Salt Lake City, UTN315PCPapa Charlie LLC · Provo, UTN316EWEdson LLC · San Angelo, TX
Back to AD 2016-12-01