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.
N181MWCsa Aircraft Leasing LLC · Salt Lake City, UTN181SCAlpha Charlie Aviation LLC · Oregon City, ORN181TWTom Wood Aviation Inc · Fishers, INN1820EAtp Aircraft 6 LLC · Wilmington, DEN1823EAtp Aircraft 6 LLC · Wilmington, DEN1825EAtp Aircraft 6 LLC · Wilmington, DEN1828EAtp Aircraft 6 LLC · Wilmington, DEN182MASterling Flight Training LLC · Jacksonville, FLN182NWNorthwestern Michigan College · Traverse City, MIN1838EAtp Aircraft 6 LLC · Wilmington, DEN1839EAtp Aircraft 6 LLC · Wilmington, DEN183NWNorthwestern Michigan College · Traverse City, MIN1842EAtp Aircraft 6 LLC · Wilmington, DEN184AFG & M Aircraft Inc · Wheat Ridge, CON184NWNorthwestern Michigan College · Traverse City, MIN1859UMustang Sally Aviation LLC · Camden, SCN185CPCivil Air Patrol · Maxwell Afb, ALN186CPCivil Air Patrol · Maxwell Afb, ALN186CSFlying Rock Aero LLC · Sunnyvale, CAN18728Atlas Aviation Tampa Inc · Tampa, FLN187CACivil Air Patrol · Maxwell Afb, ALN187HSGlidewell Aviation Inc · Parkland, FLN1882SWings Over L A Aviation LLC · West Hills, CAN1884MMontgomery Aviation LLC · Zionsville, INN188AHAlf Ix LLC · Chicago, ILN188VEFly Skyhawk LLC · Peoria, AZN18ACHillsboro Aero Academy LLC · Hillsboro, ORN18LWDirty Side Down Aviation LLC · Georgetown, TXN190LPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeN190MEMenagerie Enterprises Inc DBA · Denison, TXN1916JCareer Track 2 LLC · Wilmington, DEN1919UD&S Aviation LLC · Spring, TXN191CACsa Aircraft Leasing LLC · Salt Lake City, UTN1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLN192JPBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN192MCWarrington Flying Club Inc · Doylestown, PAN192MEKindrick Jan W · Mt Vernon, TXN1931HMountain Air Aviation LLC · Fruit Heights, UTN1934GAero-Tech Services Inc · Lititz, PAN19369Aci Aviation LLC · Costa Mesa, CAN1939SFallon Timothy · Center Barnstead, NHN193MEHorizon Flight Center LLC · Chesapeake, VAN193THWingsleasing LLC · Wichita, KSN1947LCal Aggie Flying Farmers · Davis, CAN194SPFly4sp LLC · San Mateo, CAN194THWingsleasing LLC · Wichita, KSN1956VMedary Aviation LLC · Brookings, SDN195NWNorthwestern Michigan College · Traverse City, MIN1965HDeltahawk Engines Inc · Racine, WIN196MEPacific Lease · Elk Grove, CA
Back to AD 2012-22-01