AD 2007-24-13
Registered aircraft · 4,026
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:2007-24-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:2007-24-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:2007-24-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:2007-24-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.
N575MCStuteville Consulting LLC · Durant, OKN575SABarnts Sales Company LLC · Diller, NEN575TXHu Jianing · Santa Clara, CAN575WTDanemann Mark · Taos, NMN576CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN576CPQualitair LLC Trustee · MichelstadtN576DGEdge David Lee · Lumberton, NCN577DGW&E Aviation LLC · Peoria, AZN577DHHawkeye Aviation LLC · Mason, OHN577PGCirrus Design Corp · Duluth, MNN577SRSteubesand Karl · Rhinebeck, NYN578AGAlpha Gulf Holdings LLC · Wesley Chapel, FLN578CDCarothers Donald Luis · Bakersfield, CAN578CPOsman Keenan · Seffner, FLN578PSAircraft Guaranty Corp Trustee · Oklahoma City, OKN579MWCqf Holdings LLC · Fairhope, ALN579SRShepherd Kris R · Blue Ash, OHN57DB57db Aviation LLC · Fort Myers, FLN57DECape Aviation LLC · Lewes, DEN57FECavu Air LLC · Lees Summit, MON57PGShirman Leon · Redwood City, CAN57RJD&J Training Planes LLC · Logan, UTN57RXVolar Ix LLC · Edmond, OKN57RZSierra Tango Ventures LLC · Monte Sereno, CAN57SAFort Wayne Aircraft LLC · Fort Wayne, INN57TUKagley Larry D · Greenwood, SCN580SRNose Up Speed Aviation LLC · Durango, CON581CDLig Air Services LLC · New York, NYN581SDDakota Cross Winds LLC · Bismarck, NDN581THCirrus Design Corp · Duluth, MNN583CDInternational Air Services Inc Trustee · Carson City, NVN584BSch Aviation Inc Trustee · NorfolkN584CDBrothers David M Trustee · Cainsville, MON584CFGreenspace Of Virginia LLC · Forest, VAN584CPThorpe LLC · Jupiter, FLN584SRThunder Richard · San Diego, CAN5854AColorado High Plains Aviation Ltd · Englewood, CON585ABHh Aircraft LLC · Englewood, CON585CDE And J Holdings 25 LLC · El Dorado, ARN585CFBuzzing Above II LLC · Tampa, FLN585ECMc Aviation II LLC · West Palm Beach, FLN585GBCirrus Design Corp · Knoxville, TNN585GT2029 Realty Corp · Farmingdale, NYN585SRNublos Group LLC · Birmingham, ALN5863N5863 LLC · Kalispell, MTN586CAOrlando Holding Company LLC · Port Jervis, NYN586CFJbw Aviation LLC · Benton, KYN586SRFat Alberts Inc · Poteau, OKN587ATBcaa Aviation LLC · Westfield, INN587CPBear Automation Inc · Fayetteville, AR
Back to AD 2007-24-13