AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N953LCHustings Ross · Rockwall, TXN953LWWatson Frank D · Canton, PAN953MAGutierrez Francisco J · Laredo, TXN953MTMiddle Tennessee State University Aerospace · Murfreesboro, TNN953RNWeinreich Mark W · River Falls, WIN953RRJcb Aviation LLC · Paragould, ARN953SASunrise Aviation Inc · Ormond Beach, FLN953SMBogen Alfred T · Brandon, MSN953SSSinor Delbert D · Ozark, MON953TEL A Mesa Ventures LLC · Denison, TXN953TFAir Fleet Holdings LLC · Missoula, MTN953TWEllison Craig M · Sandpoint, IDN953WTDragons Fly Aviation LLC · Lantana, TXN95402Registered aircraftN95403Deffenbaugh Dennis L · Langley, OKN95404Delta State University · Cleveland, MSN95405Hovey Ryan R · Concord, VTN9540BFly8ma LLC · Big Lake, AKN9540DGibsons Gas Inc · Holland, NYN9540LCivil Air Patrol Inc · Maxwell Afb, ALN9540MBostrom Zachary J · Ballwin, MON9540PStuder Al C · Shelby, MIN9540WCarter Brian A · Paragould, ARN95418Selleck Stephen P · Colton, CAN95419Underwood William · Fargo, NDN9541KElliott Thomas W · Sarona, WIN9541YNavigated Technologies LLC · Nashville, TNN95420Registration Pending · Easton, PARegistration pendingN95422Chimera Air Inc · Maumee, OHN95423Fullerton Alan D · La Crosse, WIN95424Air69 LLC · Kaiser, MON95426Morten Jesse L · Larimore, NDN95427Mahoney Christopher P · Quakertown, PAN95428Raines Matthew A · Whiteside, TNN95429Suburban Air Corp · Castro Valley, CAN9542CSandberg Joseph · Lincroft, NJN9542HAbusham Hamed M · Upland, CAN9542UNorman Ronald Edward · Lopez Island, WAN9542WState Of North Carolina · Raleigh, NCN95431Kent State University · Stow, OHN95436Dawson Danny L · Clay, WVN95437Howard Bruce A · Santa Fe, NMN95438Jordan Kenneth R · Wake Forest, NCN9543FEvans Michael · Punta Gorda, FLN9543GHi Low Aviation LLC · Alpine, TXN9543HGonzalez-Rio Jesus A · Big Pine Key, FLN9543JKool Wings Leasing LLC · Indianapolis, INN9543L10 Skies LLC · Rockport, TXN9543MReedy Coleman · Cool, CAN9543PHerr Bridget J · Boles, AR
Back to AD 81-18-04 R2