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.
N8355AEmerald City Aircraft Leasing Inc · Port Orchard, WAN8355EHigh Noon Leasing LLC · Anchorage, AKN8355PSutliff Larrie G · Briarcliff Manor, NYN83566Downes Dennis G DBA · Saltsburg, PAN8356ESky West Aviation Inc Trustee · Albuquerque, NMN8356JWissam Habbal · Rosamond, CAN8356PEarl Tim G · Plymouth, CAN8356REmerald City Aircraft Leasing Inc · Port Orchard, WAN8356VGroh David A · Mason, MIN8356WSmith Randall K · Wilton, CAN83572Pacific Aviation LLC · Cottage Grove, ORN83573Frazier Aviation LLC · Ontario, ORN83577Ennen Rick M · Bottineau, NDN83579Mak Air Ventures LLC · Smithfield, NCN8357PHames David W · Amarillo, TXN8357RRegistration Pending · Fort Worth, TXRegistration pendingN8357VHaas Daniel S · Camarillo, CAN83580Lazy Ye Cattle Co · Dodson, MTN83582Johnson Gavin Howard · Anchorage, AKN8358FHolt Helicopters Inc · Uvalde, TXN8358LOc Flight Lessons LLC · Costa Mesa, CAN8358MSky Blue Holdings LLC · Park City, UTN8358RHight Mayon C · Snohomish, WAN8358WChaney Eddie L · Douglas, GAN8358YGruenbaum Michael S · Eastvale, CAN8358ZMinella Frank A · Old Forge, PAN83594Sjogren Risto L · Felton, CAN83596Carlson Farms Inc · Plentywood, MTN83598Liley Diana H · Anchorage, AKN8359VCressman Scott M · Mount Pleasant, TXN8359WMarble Jere D · Dayton, NVN8359XW&H Services LLC · Boerne, TXN8359YManyak Louis J · Inglis, FLN835AKOld City Helicopter Sales LLC · Saint Augustine, FLN835ATDot Aviation LLC · Wilmington, DEN835BCShoreline Home Services Inc · Wilmington, NCN835CPCivil Air Patrol · Maxwell Afb, ALN835EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN835FGRidgeline Assers LLC · Wilmington, DEN835KSKansas State University · Salina, KSN835NDUnd Aerospace Foundation · Grand Forks, NDN835PDDye Paul F · Dayton, NVN835SSpirit Of Flight LLC · Noblesville, INN835SHBuell Travis W · Harper, TXN835SWBrakey Richard F · Amarillo, TXN836Furnari Jonathan P · Whitewright, TXN83604Crowe Kirby H · Haskell, OKN8360RSan Diego Community College District · San Diego, CAN8360VGcgk Air Ventures LLC · Sheridan, WYN8360YOtto Aviation LLC · Gilbertsville, PA
Back to AD 81-18-04 R2