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.
N201SPColorado State Patrol · Denver, CON202PEDc Ways LLC · Macon, GAN202TWTw Leasing LLC · Oxford, CTN206AFGpfp LLC · Portsmouth, NHN207NWNorthwest Concrete Products Inc · Woodward, OKN207NXIntermountain Medical Transport LLC · Salt Lake City, UTN207STTwo Bells Aviation LLC · Rockville, MDN208CGAspen Homes And Development LLC · Coeur D Alene, IDN209PBValiair Limited Co Trustee · Casper, WYN20JTN20jt LLC · Somers, CTN212ALAir Methods LLC · Greenwood Village, CON212MASaurenman Aviation LLC · La Verne, CAN212MFTw Leasing LLC · Oxford, CTN212PBGuardian Flight LLC · Lewisville, TXN212PKOc Aviation LLC · Victoria, TXN213ALAir Methods LLC · Greenwood Village, CON213GPc12ng LLC · Cartersville, GAN213KPMaroon & Gold LLC · Albuquerque, NMN214ALAir Methods LLC · Greenwood Village, CON214CSHinterland Holdings LLC · Anchorage, AKN214GGRegistered aircraftN214MGMullet And Grits II LLC · Muskogee, OKN214NXLife Flight Network LLC · Aurora, ORN216KCBlack Kettle Inn LLC · Cabool, MON217EBRapids Camp Lodge Inc · King Salmon, AKFirst renewal noticeN218CRegistered aircraftN218PETourico Holiday Flights LLC · Maitland, FLN219PCRyan Air Inc · Anchorage, AKN219TXTexas Department Of Public Safety · Austin, TXN219XN6049s LLC · Fullerton, CAN21AUBoeing Co · Renton, WAN21NXKnobelsdorff Aviation LLC · Goodhue, MNN21WLAdams Aviation Services Inc Trustee · Wilmington, DEN220JPDragonglass LLC · Denver, CON221DEOtter Air Services LLC · Grand Rapids, MIN221MDSwiss Air LLC · Camp Hill, PAN221NGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN221NXMassive Prints Inc · Rancho Dominguez, CAN221PCRegistered aircraftN221RCBtfd LLC · Reno, NVN221XXN221yy Corp Trustee · Wilmington, DEN2220MObsidian Leasing LLC · Lehi, UTN2222CDodson International Parts Inc · Rantoul, KSN222CMBriar Lakes Productions Inc · Palestine, TXN222DEOtter Air Services LLC · Grand Rapids, MIN223LMLgp Hidden Oaks LLC · Fulshear, TXN2244Post-Tension Services Of Texas LLC · Dallas, TXN224SLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN224TWBedford Partners LLC · Oxford, CTN226AALegacy Air 03 LLC · Grand Forks, ND
Back to AD 2016-12-01