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.
N466CDAsa Obion LLC · Union City, TNN466CESilver Fern Aviation Consulting LLC · Port Orange, FLN466MPMolar Air LLC · Martinez, GAN466PJv Aviation LLC · Johnston, RIN466TBnab Air LLC · Saint Louis, MON4671KNifong Robert B · Jacksonville, FLN4672KMartin Richard E Trustee · Colorado Springs, CON4674NBorderline Sky LLC · El Paso, TXN4674UKlein David · Sebastopol, CAN4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNN4678QPrairie Dog Aviation LLC · Sioux Falls, SDN4679YExtreme Air LLC · Cottage Grove, WIN467CCOld South Construction Of Tennessee LLC · Franklin, TNN467CDStarship 1 LLC · Houston, TXN467DBParamont Services Inc · Newbury Park, CAN467PZAirline Training Professionals LLC · Wilmington, DEN467WFSanstone Aviation LLC · Arden, NCN4680NRentz Communications Inc · New Smyrna Beach, FLN468CDSoar Above LLC · Westminster, MDN468CLVicash LLC · Dover, DEN468DABulk Transfer LLC · Horseshoe Bay, TXN468GTTreble Teal LLC · Hood River, ORN468KAJm Aero Holdings LLC · Naples, FLN468KCSkyway Assets LLC · Hyde Park, UTN468MBDelaware Aircraft Trust LLC Trustee · New Castle, DEN468MREastern Aerospace LLC · Wilmington, DEN468PN Fl Servicing LLC · Santa Rosa Beach, FLN468SEH & R Cirrus LLC · Vero Beach, FLN4690UKim Hansen Co · Burley, IDN4694YKempton Chevrolet Buick Ltd · Safford, AZN4694ZKyro Consulting LLC · Williamsburg, VAN4695AAgarwal Ravi · Bath, PAN469ALDudzinsky LLC · Omaha, NEN469CDRockin Robin Aviation LLC · Natchez, MSN469CPN469cp LLC · West Hollywood, CAN469FDCirrus Design Corp · Duluth, MNN469GBSale Reported · Palm Coast, FLSale reported, pending cancellationN469HHowatt Air Inc · Langdon, NDN469HPTrussell David · Fremont, CAN469JGJg Aviation LLC · Coral Gables, FLN469MMMm Consulting Services · Fort Smith, ARN469SRRbnt LLC · Mason, OHN469SYAerotrust Services Corp Trustee · Wilmington, DEN46BAArrington Investments Inc · Andrews, SCN46CNWonka Enterprises LLC · Washington, UTN46CPKtas LLC · New York, NYN46CRBas Part Sales LLC · Greeley, CON46CSPlane Fun Inc Tr Trustee · Snellville, GAN46DTEagle Ad-Venture LLC · Universal City, TXN46EHStar H Aviation LLC · Plano, TX
Back to AD 2012-10-13