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.
N771SRN771sr Inc Trustee · Wilmington, DEN772CManitoba Pacific LLC · Laguna Niguel, CAN772CCWagner William · Oro Valley, AZN772CDHarllee Cattle Company LLC · Bradenton, FLN772DBAtb Aviation LLC · Wilmington, DEN772DDN36be LLC · Wilmington, DEN772DGDg Aviation LLC · Las Vegas, NVN772LCTwo Bad Dogs LLC · Denver, CON772MCayle Jonathan · Rochester, MIN772MDMary Rabbit LLC · Saratoga, CAN772PCThompson John Christopher · Dallas, TXN772RGFresh Wind Gts LLC · Knoxville, TNN772TTBrightwater Enterprises LLC · Lakeway, TXN7734MHeinrich Bruce · East Burke, VTN77350Bottom Line Technologies Inc · Columbia, MDN7736KValiair Lc Trustee · Casper, WYN773ABCirrus Aviators LLC · Leesburg, VAN773BBMinnesota Made Hockey Inc · Edina, MNN773CDMississippi Pepin Flyers LLC · Hager City, WIN773CMZee Lee Air LLC · Fort Lauderdale, FLN773CVRengel & Co Architects Inc · Tustin, CAN773DCFlying Rose LLC · Sparks, NVN773DVDuet Ventures LLC · Isle Of Palms, SCN773GMBluff Aviation LLC · Lewes, DEN773GPBb Co LLC · Parker, CON773MGSei Bryan J Trustee · Albuquerque, NMN773SRTiger Eye 2004 LLC · Montauk, NYN773TA309 Holdings LLC · Wilmington, NCN774CDValiair Limited Co Trustee · Casper, WYN774CSWyo Ventures LLC · Buffalo, WYN774DCBas Part Sales LLC · Greeley, CON774EBBruce Erik · Yreka, CAN774MWOptus Air LLC · Wilmington, DEN774PLTop Gun G Force LLC · Eatonville, WAN774RDDemuth Roger C Trustee · Valley View, TXN774SFOktex Air LLC · Ardmore, OKN774SRLevesque Jay F · Rochester, NHN774TRMb Air Inc · Fort Myers, FLN7750QJohnson Gregory L · Orange, CAN77554U S Department Of The Interior · Boise, IDN7758BMiller Jeffrey A Trustee · Tucson, AZN775ABLand Air & Sea LLC · Charlotte, NCN775AR826tw LLC · Haverford, PAN775CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN775EWThree Three Foxtrot Inc · Cedar Falls, IAN775JWCunningham William R · Broken Arrow, OKN775RCAirswiss Inc · Wilmington, DEN775ZHundal Medical Corp · Malibu, CAN7763BWyndymere Harbor LLC · Port Saint Lucie, FLN7763YBen Shuzen LLC · White Plains, NY
Back to AD 2012-10-13