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.
N908JDNash Gregg Lynn · New Waverly, TXN908MCL2 Leasing LLC · Orem, UTN908NDUniversity Of North Dakota · Grand Forks, NDN908QCCook Hugh Q · Aurora, CON908SCGomez Ryan Rene · Fort Worth, TXN908TBushby Harvey M · Minooka, ILN908VLBlue Waters Air Charters LLC · San Juan, PRN908WAPea-Wayman Flight LLC · Daytona Beach, FLN90908Charles Wilford W · Big Lake, AKN9090BHaynes Aviation LLC · Wetumpka, ALN9090LBascue Brandon D · Ward, ARFirst renewal noticeN9090WRyeco Inc · Lewes, DEN9090XTahaney David J · Fox Lake, ILN90912Snead Douglas A · Derby, KSN90913Prime Travis R · Hammonton, NJN90915Cnj Flying Inc · Flossmoor, ILN90919Allman Joseph S · Blackstone, VAN9091CYoung Gregory S · Riverside, CAN9091DCanton Logan J · Petersburg, AKN9091HCampbell Raymond · Box Elder, SDN9091LAmelia Reid Aviation LLC · San Jose, CAN9091VScheutzow David P · Medina, OHN9091YCsa Investments LLC · Wayne, PAN90922Blair Ernest J · St Thomas, NDN90923Gravesen Mark A · Kenmare, NDN90928Skunberg Leonard T · Salmon, IDN9092CAdirondack Aviators LLC · Peru, NYN9092HWinemiller Stevie Dale · Swifton, ARN9092JRegistered aircraftN9092LYoung Vernon P · Metter, GAN9092RSmith Michael A · The Villages, FLN9092VHogan Roger C · Virginia Beach, VAN9092WLong Earl V III DBA · Wichita, KSN9093Zimsim LLC · Charleston, SCN90931Davies Donald K · Hastings, MNN90932Hall Air Inc · Weiner, ARN9093FArcher 93f LLC · Danvers, MAN9093JRichardson Harley T Jr · Mullins, SCN9093KPdg Leasing LLC · Maryland Heights, MON9093LBielamowicz John Kolbe · Waxahachie, TXN9093SEllis Derek J · Austin, MNN9093ZCloud Niner LLC · Furlong, PAN90943Center Of Gravity LLC · Elmira, NYN90945Pennison Scott J · Nikiski, AKN90947Macleod Andrew S Trustee · Anchorage, AKN90948Ccf Ventures Inc · Bangor, MEN9094JDagny Aviation LLC · Gardendale, TXN9094KWomack-Kalla Dennis E · Philadelphia, PAN90957Cubcrawlers LLC · Cocoa, FLN90963Bloom Wade D · Eagle, ID
Back to AD 81-18-04 R2