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.
N101JHHi-Per Aviation Inc · Arroyo Grande, CAN101JMSale Reported · Clay Center, KSSale reported, pending cancellationN101KGQualitair LLC Trustee · MichelstadtN101MEIbs America Corp · Wilmington, DEN101MTAllman Air LLC · Blackstone, VAN101MWMaroon Creek LLC · Aspen, CON101PAKeenan Mark · Chico, CAFirst renewal noticeN101PMKasper John D · Oxford, ALN101PTN28179 Inc · West Gilgo Beach, NYN101TPSamurai Ventures LLC · Hillsborough, CAN101VMKrowel Nicholas E · Woodstock, GAN101WEBadgerland Aero LLC · Las Vegas, NVN101XMMaier Gerard · Hartford, WIN101ZACirrus Sr22 10117 Inc Trustee · Wilmington, DEN1020AIrving Donald J · Deland, FLN1020VCraig Air Inc · Wasilla, AKN1021N1021 Inc · Wilmington, DEN1021URegistered aircraftN1021WGreystone Enterprises Inc · Oklahoma City, OKN10222Willard Gregory M · Bonita Springs, FLN1022FGoodfellow Malcolm D · Seattle, WAN1022UCivil Precast Corp · Ridgeland, MSN1023FWinter Karl · Litchfield Park, AZN1023WGoldeagle Flyers Inc · San Jose, CAN10242Alexander Holding Services Inc · Newark, DEFirst renewal noticeN1024TBarnwell John Randel · Conroe, TXN1024ZAqua Men Service LLC · Temple, GAN1025WBancroft Maurice J · Rio, WIN1026ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN1026FDeramus Eugene T · Garden Ridge, TXN1026TEdens Erik · Scottsdale, AZN1027CFacchiano Vincent R · Belvidere, ILN1027DRobins Jack S · Saint Charles, IDN1027TEye Candy Aircraft LLC · Jacksonville, FLN1028FLunoe Leif C · Anchorage, AKN1028RGarner Donald G · Greeley, CON1029MHarris Charles T Trustee · Thousand Oaks, CAN102ARValiair Limited Co Trustee · Casper, WYN102BNDelta State University · Cleveland, MSN102CCPj Squared LLC · San Antonio, TXN102DLP & G Trading Co Inc · Trenton, NJN102DWFlyboy Aviation LLC · Memphis, TNN102FPN9817k LLC · Fredericksburg, VAN102HCMerz Investments LLC · Renton, WAN102HLKopp Michael · Reno, NVN102JJGrose Christopher E · San Antonio, TXN102JMHeld John S · Cincinnati, OHN102KWVentura Douglas · Cambridge, MDN102KYPatriot Aviation LLC · Rostraver Township, PAN102LTSandjuice LLC · Gainesville, FL
Back to AD 2016-16-12