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.
N771PTPilot Training Center LLC · Miami, FLN771RANational Aviation Academy Of Mississippi Inc · Clearwater, FLN771RCReynolds Ronald · Ammon, IDN771SHHillsboro Aero Academy LLC · Hillsboro, ORN771TMMid-South Aviation LLC · Caruthersville, MON771UTecnam US Inc · Sebring, FLN771VYGarcia Pedro · Hudson, OHN771WKalmar Istvan · Keller, TXN771WSCampbell Reginald G · Hilo, HIN7720DBarnhill Jerry D · Longville, LAN7720GZulu Jets LLC · Boerne, TXN7720J3c Aviation Lc · Clare, MIN7720WLagrange LLC · East Helena, MTN7720YEastern Kentucky University · Richmond, KYN7720ZAnderson Joel M · Starkweather, NDN7721BHill Jack D · Tulsa, OKN7721DRenick Tyler C · Wichita Falls, TXN7721GWurtsboro Airpark LLC · Wurtsboro, NYN7721HRegistration Pending · Juneau, AKRegistration pendingN7721JJgm Aviation LLC · Spring, TXN7721NRome Nicholas S · Olathe, KSN7721WKosobud Timothy J · Adams, WIN77222Davis Sam Alan · Wendell, NCN7722GKnaack Roland · Cumming, GAN7722HRickman Allen K · Absarokee, MTN7722ZCentral California Soaring Association Inc · Avenal, CAN7723DLutz Roald F · Sandia Park, NMN7723JHabig Robert D · Sheridan, INN7723NFord Charles D · Clifton, TNFirst renewal noticeN7724GWind Walker LLC · Tucson, AZN7724PWay Steven J · Colleyville, TXN7725KKansas State University Salina · Salina, KSN7725NHangar Twenty Two Aviation LLC · Athens, TXN7725PTully Martin · Idalou, TXN7726DClaypool Bruce W · Bethel, AKN7726KMcdonald Walter S · Park City, UTFirst renewal noticeN7726POcallaghan David · Bonney Lake, WAN7726TWildwood Aerospace LLC · Cabot, ARN7726WJrw Flight LLC · Huntsville, MON7727GSkyhawk Air LLC · Brunswick, GAN7727PTaylor Aviation LLC · Corning, ARN7727WAukee Isaac J · Ironwood, MIN7728GTakeflight LLC · Spanish Fork, UTN7728JClear Skies Leasing LLC · Okemos, MIN7728KPolkowske Leroy A · La Jara, CON7728NP-Factor Aviation LLC · Hoover, ALN7728WSchrage Kevin J · Trevor, WIN7729CPeterman Keith · Taylorsville, KYN7729GValiair Lc Trustee · Casper, WYN7729HHayes Daniel S · Waupaca, WI
Back to AD 81-18-04 R2