AD 2012-22-01
Registered aircraft · 3,852
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-22-01')
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-22-01')
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-22-01') 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-22-01') 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.
N227CPCivil Air Patrol · Maxwell Afb, ALN227TWChristiansen Aviation LLC · Wilmington, DEN227WCHuerta Holdings Inc · Woodland Hills, CAN22801Career Pilot Training LLC · Wilmington, DEN22803Career Pilot Training LLC · Wilmington, DEN22806Career Pilot Training LLC · Wilmington, DEN22807Career Pilot Training LLC · Wilmington, DEN22808Career Pilot Training LLC · Wilmington, DEN22809Career Pilot Training LLC · Wilmington, DEN22810Career Pilot Training LLC · Wilmington, DEN22813Career Pilot Training LLC · Wilmington, DEN22816Career Pilot Training LLC · Wilmington, DEN22818Career Pilot Training LLC · Wilmington, DEN228TWNorth Delta Aviation LLC · Blytheville, ARN22904Phoenix East Aviation LLC · Daytona Beach, FLN2290AOrtega Aviation Services LLC · Wichita, KSN2291CForty Four Fifteen LLC · Reno, NVN2296NMacsdea LLC · Van Nuys, CAN2298WGoli Aviation LLC · Raleigh, NCN229METom Wood Aviation Inc · Fishers, INN229WCJeffery & Weiss Holdings LLC · Long Beach, CAN22SJWright James M · San Diego, CAN2302YMustang Sally Aviation LLC · Camden, SCN230EPEpic Aviation Inc · New Smyrna Beach, FLN230KGAlf Ix LLC · Chicago, ILN230SAStature Aviation LLC · Addison, TXN23104Atp Aircraft 1 LLC · Wilmington, DEN23107Atp Aircraft 1 LLC · Wilmington, DEN23108Atp Aircraft 1 LLC · Wilmington, DEN23110Atp Aircraft 1 LLC · Wilmington, DEN23116Atp Aircraft 1 LLC · Wilmington, DEN23118Atp Aircraft 1 LLC · Wilmington, DEN23120Atp Aircraft 1 LLC · Wilmington, DEN23122Atp Aircraft 1 LLC · Wilmington, DEN23124Atp Aircraft 1 LLC · Wilmington, DEN23127Atp Aircraft 1 LLC · Wilmington, DEN23134Career Track 2 LLC · Wilmington, DEN23137Career Track 2 LLC · Wilmington, DEN2316TAircraft Solutions Group LLC · Englewood, CON23172Career Track 2 LLC · Wilmington, DEN23175Career Track 2 LLC · Wilmington, DEN23176Career Track 2 LLC · Wilmington, DEN23177Career Track 2 LLC · Wilmington, DEN231EPEpic Aviation Inc · New Smyrna Beach, FLN23203Wings Over Texas Holdings LLC · Denton, TXN2322YIn Flight Aircraft LLC · Howell, MIN2328RYoung Airmans Association Inc · Arverne, NYN232EPEpic Aviation Inc · New Smyrna Beach, FLN232FFArq Aviation LLC · Wilmington, NCN2330FFlight Operations Aircraft LLC · Wilmington, DE
Back to AD 2012-22-01