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.
N550BRF P And P I Enterprises Inc · Oceanside, CAN550CDCoen Scott D · Kingsport, TNN550EFSteinbruegge David M · Durango, CON550FK38884 LLC · Moorhead, MNN550GKGreen Of Peak LLC · San Francisco, CAN550GRClark Robert E · Meridian, MSN550JKTaffet Jay · New Orleans, LAN550KBPradelt Charles · Queen Creek, AZN550KCRegistered aircraftN550LWWasserott Charles G · Owasso, OKN550MHAviation Education Services Inc · Tetonia, IDN550MPPal Aviation LLC · Natchez, MSN550NCTri-State Communications Inc · South Sioux City, NEN550RESimply Living LLC · Fort Myers, FLN550RGBr Ventures LLC · Port Orange, FLN550RJHovermale Ken · Portland, MEN550RXRegistered aircraftN550SNortheast Cubs LLC · Wilmington, DEN5511CDss Consulting LLC · Omaha, NEN5515CIsland Fliers LLC · Sheridan, WYN5516CCarson Kirk · Dalhart, TXN5517UKoegel John C · Flint, MIN5519UBurlington Veterinary Systems LLC · Burlington, KSN551ATCorellian Spacecraft LLC · Leesburg, VAN551BPPalmer John Michael · Saint Louis, MON551CDBwr Group LLC · Hobbs, NMN551DBKirby Ramsey Aviation Group LLC · Almont, CON551JWDepato LLC · Paradise Valley, AZN551SGAviation Module LLC · Los Angeles, CAN551SRN551sr Aviation LLC · Roswell, GAN551USFar Side Aero LLC · Santa Maria, CAN5522COswald Ron · Eden Prairie, MNN5522TBeechcraft Heritage Museum Inc · Tullahoma, TNN5523YSimmons Scott · Anchorage, AKN5524VRamsey Jarrod Ross · Chicago, ILN5527AMokiy LLC · Aurora, ORN5529VCandlestick Aviation Services LLC · Lewes, DEN552AMCirrus Sr22t 0189 Inc Trustee · Wilmington, DEN552CDDirect Internet Inc · Harsens Islands, MIN552CMCm552 LLC · Katy, TXN552FSSciortino Frank M · Oswego, NYN552SRGenung Tobin J · Ocala, FLN552ZSTuolumne Ridge LLC · Modesto, CAN5530XFaulhaber Orlin W · North Platte, NEN5534RHanson David J · Charlotte, NCN5535WGpd LLC · Saint Louis, MON55367Mammoth Toys Inc · Santa Ana, CAN5536LAdvance Air LLC · Wichita, KSN5537CM G Aviation · Tyler, TXN5537VWheelzup LLC · San Carlos, CA
Back to AD 2012-10-13