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.
N321JTPcss Aviation LLC · New Albany, MSN321JWTahoe Blue Medical LLC · Incline Village, NVN321JZGolden Gate Meat Company Inc · Richmond, CAN321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLN321LLTwocarols LLC · San Francisco, CAN321LTTailwinds & Tanlines LLC · Fort Worth, TXN321MTIflyhi Aviation LLC · Sanbornton, NHN321PGN321pg Corp Trustee · Wilmington, DEN321PMPilotpros Training LLC · Longview, TXN321RPIsrael Oscar M III · Sinton, TXN321SETesla Aviation LLC · Mount Pleasant, SCN321TFStarhawk LLC · Denver, CON321TSSelby Arrie Trustee · Equality, ALN321TTN321bluesky LLC · Sugar Land, TXN321WDWhiskey Delta Holdings LLC · Collinsville, TXN321WPRadmall LLC · Commerce City, CON321WRFord Paul · Princeton, NJN321WYWhitescarver Suzanne L Trustee · Las Vegas, NVN3220JFagen Inc · Granite Falls, MNN3222PAmlz Air LLC · Rockville, MDN3222UMilpower Inc · Nampa, IDN3223BTechmur LLC · Loudonville, NYN3224QRech Jack R · Mohave Valley, AZN3225KWjm Aviation LLC · Friendswood, TXN3226BSooner Aviation LLC · Norman, OKN3226JSimms Matthew · Davie, FLN3226QDenning Aviation Inc · Fort Madison, IAN3227GOgden Scott S · Collierville, TNN3227XSasar Inc · Wilmington, DEN3228WChris I Lee Md Inc · Rowland Heights, CAN3228XN3228x LLC · Colusa, CAN3229GAero-Mark LLC · Winchester, KYN322AJGracop LLC · Amarillo, TXN322AMProfessional Pilots LLC · Duluth, MNN322BGGross Aircraft LLC · Dover, PAN322CDGnc Industries Inc · Pocahontas, ARN322CWGallagher Maria J · Lakewood Ranch, FLN322EDHargrove David L · Bozeman, MTN322HBMotov8d Horizons LLC · Spring, TXN322JBJ & R Aviation Inc · Sioux Falls, SDN322KACf Aviation LLC · Collierville, TNN322LKFindley Air LLC · Temecula, CAN322MSMes Fire Investigations Inc · Wilmington, DEN322PBRegistration Pending · Webster, WIRegistration pendingN322PMMsr Aviation LLC · San Diego, CAN322PTMaloy Aviation LLC · Telluride, CON322RMPhillips George Thomas · Carson City, NVN322RWKraemer Jeremy A · Melrose, MNN322TWRegistration Pending · Fairview, NCRegistration pending, pending cancellationN322WAAlderman & Company Wings LLC · Danbury, CT
Back to AD 2012-10-13