AD 2008-14-13
Registered aircraft · 5,659
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:2008-14-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:2008-14-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:2008-14-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:2008-14-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.
N113GSSchulte Flyers LLC · Union, KYN113KKKns Air LLC · Portsmouth, NHN1144GLean Of Peak Aviation LLC · Kempner, TXN1149CSperanza David N · Gettysburg, PAN114BSBravo Sierra LLC · Seattle, WAN114CACirrus Design Corp · Duluth, MNN114CNGlendye Aircraft LLC · Dover, DEN114MLAxis Label Inc · Hilliard, FLN1154ZRegistered aircraftN1158CZbylut Luke · Amherst, MAN115APFp Aviator LLC · East Setauket, NYN115AVPonyup Aviation LLC · Cleveland, OHN115CGrand Valley Air LLC · Wyoming, MIN115CDHigh Flying Investments LLC · Texarkana, ARN115CNHevven LLC · Dunedin, FLN115DJAv8 Ohio LLC · Lancaster, OHN115MLRyo LLC · Cedar Park, TXN115MMGunner The Red Baron LLC · Palm Desert, CAN115SPMinnesota State Patrol · Saint Paul, MNN116KWE2e4 Labs LLC · Wilmington, DEN11770Cirrus Design Corp · Duluth, MNN117BKBravo Kilo Capital LLC · Naples, FLN117FDTush Mason Lee Jr · Sarasota, FLN117GFive Bros Transportation LLC · Hobbs, NMN117HCHm Aviation LLC · Lake Wales, FLN117KCElektra Air LLC · New York, NYN117KDCirrus Pompano Flyers Inc · Fort Lauderdale, FLN117LFD&E Aircraft LLC · Newark, OHN117MMlp Recreation LLC · Lewes, DEN117SMSo Lucky Two LLC · Wilmington, NCN118ARAr Ariel · Fort Lauderdale, FLN118CHSandstrom Brent B · Gilbert, AZN118GCCole Chevrolet Inc · Pocatello, IDN118GSOliver Mark Christopher · Greenwood, SCN118HHN112hh-2 LLC · Whiting, VTN118PGAircraft Guaranty Corp Trustee · Oklahoma City, OKN118WHWindward Aero LLC · Moultonborough, NHN119ALSch Aviation Inc Trustee · Sporle Kings LynnN119ANClear Skies Aviation LLC · Broadlands, VAN119LKMy Wings LLC · Eden Prairie, MNN119MKFlatirons Aviation LLC · Naples, FLN119RPTrdz LLC · El Segundo, CAN119WJLauber Land Developers LLC · Saint Louis, MON119WZWhiskey Zulu LLC · Urbandale, IAN11CTNwm Advisors LLC · San Luis Obispo, CAN11DFFull Flaps 11df LLC · Malvern, PAN11MZD&K Harvesting Inc · Labelle, FLN11PRGo Anywhere Do Anything LLC · South Lake Tahoe, CAN11PSPro Ag Aviation LLC · Luverne, MNN11SDHarris County Sheriffs Office · Spring, TX
Back to AD 2008-14-13