AD 83-22-06
Registered aircraft · 11,722
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:83-22-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-22-06')
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:83-22-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-22-06') 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.
N1099FSaal Christopher J · Anchorage, AKFirst renewal noticeN109CFMarigi William Kihara · Worcester, MAN109FRWilson Ronald Earl · Sedona, AZN10CRCarlile Aviation LLC · Peculiar, MON10DJNovak Todd · Lumberton, NJN10GRamsey Wayne · Abilene, TXN10GLMakulu Adventures LLC · Fort Pierce, FLN10JVHale Thomas O · Cotuit, MAN10TUAction Aviation LLC · Idaho Falls, IDN10VFAce Aircraft Leasing Inc · Nazareth, PAN10ZTVliegtuig LLC · Plattsmouth, NEN1100UThomas Jennifer G · Dayton, OHN1102GGlassy Water LLC · Brier, WAN110RJMathias Ralph · Long Beach, CAN11131Gaglioti John · Monterey, CAN11133Hanus David S · Mound, MNN11179Holloway David · Auburn, CAN11182Smith Brian · Roanoke, TXN11185Stancil Joe E Jr · Eagle River, AKN111BLLandry Patrick Todd · Georgetown, TXFirst renewal noticeN111CAce'S Hangar LLC · Bentonville, ARN111EXNew Orleans Aviation LLC · Covington, LAN111EYHook Steven · Pasco, WAN111FFGutierrez Isaias · Fontana, CAN111GN111g LLC · Longmont, CON111HPFlying Aces Aero-Fleet Inc · Guyton, GAN111HVBga-Viation · Bennettsville, SCN111LHSuperior Aviation Gateway LLC · Tampa, FLN111RKSan Carlos Flight Center Inc · San Carlos, CAN111SRPayne John A · Bloomington, ILN111ZYSkywarrior Flight Training Inc · Pensacola, FLN1126CBriggs Jonathan · Merritt Island, FLN112DSCarter Erick D · Eugene, ORN112THHanson David J · Elgin, TXN1135FLong Duane C · Baskin, LAN1136GBurnside Thomas L · Kansas, ILN113CJMarshall Joshua · Chuckey, TNN113FASale Reported · Dallas, TXSale reported, canceledN113HBSnyder Shad J · Quincy, WAN113TBBeaudoin Todd · Castleton, NYN1145FGurke George J · Anchorage, AKN1147VRegistration Pending · Moore, OKRegistration pendingN114CZMinnesota Department Of Public Safety · Saint Paul, MNN114FAJprg Aviation Inc · Orlando, FLN114WPUniversal Aviators Academy Inc · El Monte, CAN1152VGolden Eagle Consulting LLC · Williston, NDN11541Upskirt Aviation LLC · Fredericktown, MON1157VJohnson Lisa Nicole · Klamath Falls, ORN1159VShular Rodger D · Antelope, CAN115AWMillican Marc J · Anchorage, AK
Back to AD 83-22-06