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.
N5791DBrown Todd G · Corvallis, ORN5791FTihomirovs Dennis · Piseco, NYN5791LGuytek Aviation LLC · Margate, FLN5791WMotta Ron DBA · West Palm Beach, FLN5792PLadet William D · Las Vegas, NVN5792QScott David L · Nampa, IDN5792WSchulman Henry N · Mc Ewen, TNN5793HZrelak Patrick · Apple Valley, CAFirst renewal noticeN5793UDfw Skydreams LLC · Fort Worth, TXN5794HChristopherson Jack T Trustee · Overgaard, AZN5794LVanhorn Wyatt A · Macon, GAN5794UBuckley Joseph · Mora, MNN5794VHand Timothy P · Osage Beach, MON5795CHancock James T · South Saint Paul, MNN5795QStandard Charter LLC · Centennial Park, AZN5795UAg Air Squardron One LLC · Saint Joseph, ILN5795VTech Specialty Services LLC · Killeen, TXN5795WMyer Lucas O · Huntsville, ARN5796NClausing Howard · Menomonie, WIN5796QFortier Jeremy · Alma, ARN5796ZJankow Edward W · Clinton Township, MIN5798HKroenlein Donald G · Moweaqua, ILN5798LLymburner Lawrence E · Lehigh Acres, FLN5798PCiotta Anton Albert · Wallingford, CTN5798QBradley Brian · Las Vegas, NVN5798VHarlow Daniel E · Spotsylvania, VAN5799DBusse Charles U · Oakwood Hills, ILN5799FDunten Teri · Moses Lake, WAN5799LYoder George R · North Pole, AKN5799PMorgan E Neal · San Diego, CAN5799QHanson Bryan R · Shawnee, KSN5799URowe James H · Warrington, PAN579BWBridgewater State University · Bridgewater, MAN579CAMcnamer Martin J · Dubuque, IAN579CPCivil Air Patrol · Maxwell Afb, ALN579DBWeiss Bernard · Saint Paul, MNN579DRRobb David M · Newnan, GAFirst renewal noticeN579ER22 H20 LLC · Montgomery, TXN579JKKopacz Thomas H · Glen Flora, WIN579LMBnr Adventures LLC · Kalispell, MTN579MSSalmon Michael · Puyallup, WAN579PRSolla Miguel A · Dorado, PRN579RMLandrum Erik G · Austin, TXN579SIacoviello Steven A · The Woodlands, TXN579SCMahoney Steven A · Beaverton, ORN579WGTrede 2021 C172 LLC · Aurora, ORN57AASouth Texas Weather Modification Association · Pleasanton, TXN57AHSeven Mountain Flyers LLC · State College, PAN57APHouston William J · Ellensburg, WAN57AXAshby Dennis A · Paris, TX
Back to AD 81-18-04 R2