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.
N649SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN64CHAnnsec Corp · Wilmington, DEFirst renewal noticeN64CPC&A Capital Holdings LLC · Moore, OKN64EGWhite Pine Two LLC · Park City, UTN64GAEagles Soar LLC · Lewes, DEN64JUSpace Goose LLC · Newark, DEN64KTKlute Jordan · Omaha, NEN64LLReagan Ronald J · Litchfield Park, AZN64LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN64MROne Mike Romeo Leasing LLC · Las Vegas, NVN64NWSanderson Bradley Troy · Nashville, TNN64RHLandmark Aviation LLC · Hayden, IDN64RPCoe Administrators LLC · Oshkosh, WIN64RUCardinal Air LLC · Kentfield, CAN64SGCamp Illahee Inc · Brevard, NCN64TGWilliamson Russell Haire Jr · Memphis, TNN64VRVictor Romeo Aviation LLC · Hillsborough, CAN64WRAlesia Holdings LLC · Beaumont, TXN6500BAndrews Aviation LLC · Spartanburg, SCN6500GConsultant Services LLC · Stillwater, MNN6500LApsis Aviation LLC · Kentfield, CAN6500VBlue Marble Aviation LLC · Center Valley, PAN6501MByrne William J · Davis, CAN6501UMoses Hunter K · Georgetown, TXN6501ZJ&M Aviation Enterprises LLC · Greendale, WIN65029Woodberry Robert A · Mineral, VAN6502ABelair Two LLC · Lancaster, PAN6502HSimpson Equipment Leasing LLC · Hays, KSN6502XFalcon Way Partners LLC · East Helena, MTN65031Miller Lewis W · Setauket, NYN65035Vimco Aviation LLC · El Paso, TXN6503CPotts Phillip G · Chattanooga, TNN6503TRussell Construction Co · Douglas, WYN65042Blueventure LLC · Morganton, NCN6504DAirmart Aircraft Holdings Inc · Oak Ridge, NCN6504HPlane Fun Inc Tr Trustee · Snellville, GAN6504KQualitair LLC Trustee · MichelstadtN6504XMarc Pauls · Charlotte, NCN6504ZAlbertson Robbie H · Easley, SCN6505CLancair Leasing LLC · Greensboro, NCN6505LTheriot Conchita F · Anderson, SCN6505N3c3 Aviation Inc · Dania Beach, FLN6505VElg Air LLC · Birmingham, ALN6505ZJames Bryan C · Fredericksburg, TXN6506VHarper Dreams LLC · New Smyrna Beach, FLN6506ZAf Auto Group · San Jose, CAN6507VBrown Steven K · Tucson, AZN6507YJudge Allen · Lebanon, ILN6508ALynch John Z · Elon, NCN6508BTechnology Farm Inc · Tewksbury, MA
Back to AD 2012-10-13