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.
N612KPSmith Aviation Inc · Stamps, ARN612MCirrus Design Corp · Duluth, MNN612MTBinetter Samantha Ellen · Guaynabo, PRN612RCLift Aviation LLC · Loveland, OHN612SBGronemeyer Jens · Deland, FLN612SFSky West Aviation Inc Trustee · Albuquerque, NMN612SSSquishy And Squeakers Fun Flights LLC · Allen, TXN612THCarolina Aviation LLC · Wilmington, DEN612WInhoc Capital Holdings LLC · Dallas, TXN612WPRobert A Johnson Construction Lc · High Springs, FLN612XCSkiventure Holdings LLC · Wayzata, MNN6131AWigen Mary E · Porthill, IDN6131XGv Air Inc · Medford, ORN6133PEastwood LLC · Pikeville, KYN6134ECf Ranch & Cattle Co LLC · Burbank, OHN6139BFelker Gary L · Odessa, TXN613BCMcleod Properties Fontana LLC · Altadena, CAN613CMcb Consultants LLC · Camden, DEN613DRLyons Aviation LLC · Raleigh, NCN613HTSherman Jason L Trustee · O Fallon, MON613MKFlatlands Aviation LLC · Brooklyn, NYN613MMCome Fly With US LLC · Purcellville, VAN613RSGreen Trees Aviation LLC · Johnson City, TNN613STCirrus Design Corp · Duluth, MNN613VJDt Air LLC · Picayune, MSN613WTCirrus Design Corp · Duluth, MNN613XLanair LLC · Monroe, GAN614CTailwinds LLC · Warsaw, INN614CTMiles Eric · Lake Oswego, ORN614CY614 Charlie Yankee Lc · Ames, IAN614EATop Joint LLC · Huntingburg, INN614KCGbt Aviation LLC · Baton Rouge, LAN614KKKc Aviation LLC · Raleigh, NCN614PAPafford Holdings LLC · Ridgeland, MSN614PCDcg Peterson Brothers Co · Sioux Rapids, IAN614RCMacisaac Richard · Northampton, MAN614RZRasmusson Timothy · Elma, NYN614SRForest Restoration Inc · Philomath, ORN6151UMccall John A · Grapeland, TXN6151YBulloch Troy P · Cedar City, UTN6152BMohave County Board Of Supervisors · Kingman, AZN6153BCenturion Southeast Management LLC · Raleigh, NCN6154SSchreiber Stephen · Windermere, FLN6154WBramlett LLC · Carrollton, TXN6155YAl & Zal Corp · Wilmington, DEN61599Freebird Aviation LLC · Eagle, IDN6159ULaw Office Of Vincent G Rieger · Kalispell, MTN615ACManitou Aviation LLC · Camden, DEN615BBBmu22 LLC · Lancaster, OHN615BTEddies Legacy LLC · Clovis, CA
Back to AD 2012-10-13