AD 2016-06-06
Registered aircraft · 220
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-06-06')
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-06-06')
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-06-06') 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-06-06') 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.
N388EERegistered aircraftN404MAOlivia Aviation LLC · Minneapolis, MNN408DCCity Of San Jose · San Jose, CAN40GNNorthlend Logistics LLC · Belgrade, MTN426BCP-51 Investment LLC · Salem, ORN434JBInfinite Horizons LLC · Ruth, MIN446QWWkw Operations LLC · Austin, TXN456SBSurfbird Aviation I LLC · Seattle, WAN458TPValiair Limited Company Trustee · Casper, WYN465SPSamaritans Purse · Boone, NCN466BCBc Air LLC · Moses Lake, WAN466SPSamaritans Purse · Boone, NCN482GDelta Kilo Mike LLC · Rayville, LAN491KQParkwater Aviation · Spokane, WAN494KQJansair LLC · Seattle, WAN497BHMhoc LLC · Pensacola, FLN49BPBentalit Point Aviation LLC · Seattle, WAN4CMDavis Air LLC · Clinton, WAN500QKCat Air LLC · Miami, FLN501KQAnjucan 501kq Inc · Middletown, DEN504KQKodiak Aircraft Co Inc · Sandpoint, IDN50KQFaulconer Construction Company Inc · Charlottesville, VAN515CEParlueagle LLC · Montgomery, NYN527LC527 Lima Charlie LLC · Fresno, TXN528AGAh Aero Services LLC · Heber City, UTN528NRMinnesota Department Of Natural Resources · Grand Rapids, MNN528TGNorthward Bound LLC · Anchorage, AKN529NRMinnesota Department Of Natural Resources · Grand Rapids, MNN533PCJc Air Montana LLC · Missoula, MTN54BVGrigry Energy Inc · Monahans, TXN555NLDel Air Sky LLC · Dover, DEN557HDKodiak Flyers LLC · Salt Lake City, UTN564BBAircraft Guaranty Corp Trustee · Oklahoma City, OKN565EState Of Washington · Olympia, WAN565HTHammar Air LLC · West Palm Beach, FLN56SFRemote Aircraft Leasing LLC · Missoula, MTN5728GSimpson Leasing LLC · Orofino, IDN572SGBluestone Aviation LLC · Billings, MTN5799Bas Part Sales LLC · Greeley, CON579CBWoodward Aviation LLC · Alpine, TXN57KDBeratnas Aerospace LLC · Sheridan, WYN581REpsilon International LLC · San Antonio, TXN5LTDt Equipment Leasing LLC · Ten Sleep, WYN600FCFlorida Dept Of Agriculture And · Tallahassee, FLN605FCFlorida Department Of Agriculture And Consumer Svc · Tallahassee, FLN60KQTurbine Options LLC · Fishers, INN60SBN15sb LLC · Chatham, NJN619BKClipper Group LLC · Newport Beach, CAN621TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN626MMFlying Tricycle LLC · Oakland, CA
Back to AD 2016-06-06