AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N969ARDorsey & Whitney Trust Co LLC Trustee · Seattle, WAN969BJ3913x LLC · Shreveport, LAN969BSHodges Air LLC · Provo, UTN969DWDe Werd Capital Partners LLC · Los Olivos, CAN969JBRoesler Darrell E Jr · Monclova, OHN969RJAerial Robotics Inc · Richmond, UTN969SRivas Group LLC · Reno, NVN969SLWojcik Bart C · Kimberly, IDN969SRHull Michael D · West Bloomfield, MIN969SSPowell Aviation LLC · Cartersville, GAN969THMgi Proflight LLC · Las Vegas, NVN969TMTumu Leasing LLC · Orlando, FLN969TXMowata Farms LLC · Mamou, LAN96ATN105kl Holdings LLC · Sarasota, FLN96BBMagnolia Capital Group LLC · Santa Rosa, CAN96BMKm Medico LLC · Murrieta, CAN96CCInternational Air Services Inc Trustee · Carson City, NVN96DFVhl Aviation LLC · Wshngtn Ct Hs, OHN96ESPrist Vitaly · Ivyland, PAN96FKStalter David James · Goshen, INN96FLSky West Aviation Inc Trustee · Albuquerque, NMN96FUFamily Health Care Associates LLC · Manchester, KYN96KJLeslie Leasing LLC · West Palm Beach, FLN96LLHuck-Mag LLC · Plano, TXN96LSStabler Randall · Scottsdale, AZN96PTEidson Mark C · Weatherford, TXN96RHAtlanta Aircraft Group LLC · Atlanta, GAN96SAWolff Dean E · Mesa, AZN96SBBlack Pearl Aviation Inc · Sterling Heights, MIN96SYChristen John C · Tampa, FLN96WEChase Aviation De LLC · Dover, DEN96WFBrockman Leland Jay · Horseshoe Bay, TXN9700JCrux Logistics & Consulting Ltd · Las Vegas, NVN9707JTop Hand Inc · Laurel, MTN970GGValiair Lc Trustee · Casper, WYN970SScepter Aero LLC · Waverly, TNN970WZCs2 Holdings LLC · Nashville, TNN971APCirrus Design Corp · Duluth, MNN971BIron Mountain Aviation LLC · Lead, SDN971CDHodges Vehicle Rentals LLC · West Branch, MIN971DBTrg Enterprises LLC · Mclean, VAN971PDSpyglass Aircraft LLC · Milford, CTN971RBleriot LLC · East Hampton, NYN972BRArrow John · Austin, TXN972CDCranford Michael Glen · Caddo, OKN972CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN972EUAviation Trust Company LLC Trustee · Oklahoma City, OKN972JBMotley Kyle · Brentwood, TNN972JHLynetha Aviation LLC · Oshkosh, WIN972JMUltimate Holdco Inc · Mount Airy, NC
Back to AD 2012-10-13