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.
N8861NMcdonald Timothy A · Rush City, MNN8861WFrancavilla Charles · Fremont, CAN8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKN8862LTisdale Matthew · Alameda, CAN8862NHatley Wayne S · Hermitage, TNN8862TAdams Donald L · Huntsville, ALN8862YState Of Montana · Helena, MTN8863Lilly Daryl A · Winterset, IAN8863CClearsky II LLC · Tyler Hill, PAN8863DSanders Darrel T · Camp Douglas, WIN8863FCain James W · Big Rapids, MIN8863WPratt William D · Cashmere, WAN8864DMarsteller Paul A · Tallulah Falls, GAN8864LArnold Charles E · Lowell, MAN8864YMiller Donald W · Harrisonburg, VAN8865CMayo Jesse J · Fairbanks, AKN8866CEckels Shaun R · Pickerington, OHN8866FReynolds Darryl G · Wills Point, TXN8866NYu Hermon Lemuel C · Mays Landing, NJN8866WPalmer Todd J · Sherrills Ford, NCN8866YCarson Ryan P · Albuquerque, NMN8867NMulloy Dennis · Indian Mound, TNN8867PAnderson Keith C · Puyallup, WAN8867WPayne Jason S · Overgaard, AZN8867YPiper Thirty Nine LLC · Glasgow, MTN8868Hodges Jay W · Graham, TXN8868EArizona Soaring Inc · Maricopa, AZN8868JGannon Robert M · Hamburg, NYN8868PBurrough Haus Properties LLC · San Marcos, TXN8868WBolton Barbara A · Alameda, CAN8869JRoot Roger T · Moscow, IDN8869NCarland Ralph B · Altoona, PAN8869WA&O Properties LLC · Harlan, IAN8869YCome Fly Away LLC · Waterloo, ILN886ABWings Over Texas Holdings LLC · Denton, TXN886ACAir Ben Aviator Inc · Fort Pierce, FLN886ATDot Aviation LLC · Wilmington, DEN886BNairn Bryan D · Edgewood, WAN886CPCivil Air Patrol · Maxwell Afb, ALN886CTCoast Flight Training And Management Inc · San Diego, CAN886ECUp And Up Aviation LLC · Magnolia, TXN886EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN886JBRegistered aircraftN886JHJpj Aviation Holdings LLC · Wilmington, DEN886PBarrons Aviation Services LLC · Henderson, NVN886RASmith Daryl N · Coventry, CTN886RMFalkenberg Glenn R · Livonia, MIN886RVBazazan Mehrdad D · Fredericksburg, VAN886SACumbass David Shane · Douglas, GAN886SBWhitney Matt Gene · Watertown, SD
Back to AD 81-18-04 R2