AD 2016-16-12
Registered aircraft · 25,367
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-16-12')
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-16-12')
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-16-12') 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-16-12') 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.
N100NNDunnair LLC · Panama City, FLN100PCSmokey Bay Air Inc · Homer, AKN100PKAllen Chase Enterprises Inc · Oswego, NYN100PRKinder Eric Eugene Trustee · Tucson, AZN100PSG & C Property Hc LLC · San Francisco, CAN100PXS & R Air LLC · Amarillo, TXN100PZAeromotors LLC · St James, MON100RBIngraham Donald S · New Bern, NCN100RESchooler Jordan Benjamin · Hummelstown, PAN100RGN100rg LLC · Itta Bena, MSN100RZEastern Stearman Inc Trustee · Leesburg, VAN100SPWright Richard S · Half Moon Bay, CAN100TXJones Joseph Clayton · Bossier City, LAN100WMValiair Lc Trustee · Casper, WYN100WSQualitair LLC Trustee · MichelstadtN100XHBiggs Aircraft Inc · Wellston, OKN100XPHeath Darrell L · Houston, TXN100YNEnrique Angulo · San Diego, CAN100YWMps Aviation LLC · The Villages, FLN100YZCay Air LLC · North Palm Beach, FLN100ZWFetch Aviation LLC · Bonita Springs, FLN1011Martin Rex L Trustee · Bakersfield, CAN1011GInternational Air Services Inc Trustee · Carson City, NVN1011RRegistered aircraftN1012PFly Slc LLC · Salt Lake City, UTN1013LSouthwest Medical Associates Inc · Rockport, TXN1014ARegistered aircraftN1014WAnderson Timothy R · Wilmette, ILN10155Barth James T · Midlothian, TXN1015FInternational Air Services Inc Trustee · Carson City, NVN1015WStanton Thomas Michael · Mcallen, TXN1016BWatts Daniel S · Seal Beach, CAN1016CMartinek Leasing LLC · Bellbrook, OHN1016EHiggins Chris · Sammamish, WAN1016WMichael Deem Crow · Pilot Point, TXN1017CCao Gadgets LLC · Irvine, CAN1018QLambert Brent · Roanoke, VAN1018VHack Mark A · Floyds Knobs, INN1018WLampe Ryan · Leonardtown, MDN1019CHunter James A · Elizabeth City, NCN1019KPreferred Flight Management LLC · Goshen, INN1019ZJb Air LLC · Lindsay, OKN101BEOne Bravo Echo LLC · Fernandina Beach, FLN101BMTurk Mike · Pinehurst, TXN101CDCharlie Delta Aviation LLC · Marietta, GAN101DXPatierno David M · Templeton, CAN101EEAlaskan Aerial Photography LLC · Anchorage, AKN101FKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN101FRFoxfly LLC · Red Bank, NJN101GWPlan B Air LLC · Lago Vista, TX
Back to AD 2016-16-12