AD 87-20-03 R2
Registered aircraft · 54,015
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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.
N9845TGilbert Lawrence E · Titusville, FLN9845XBirney John A · Arlington, WAN98463Civil Air Patrol Inc · Maxwell Afb, ALN9846AMannen Gregory Charles II · Warren, ORN9846GFord Eagles Inc · Plymouth, MIFirst renewal noticeN9846LCivil Air Patrol Inc · Maxwell Afb, ALN98477Registered aircraftN9847ASill Phillip II · New Castle, DEN9847GPilot In Command Academy · Miami, FLN9847LJoerithan & Mp Aviation LLC · Whittier, CAN9847VWinder Editha S · Columbus, NMN98485Amelia Reid Aviation LLC · San Jose, CAN9848APearson Jeffrey W · Anaheim Hills, CAN9848CBudd Richard E · Brooksville, FLN9848GRicci Mark P · Waterford, MIN9848HBrekke Ryan S · Edmore, NDN9848JLanham David R · Visalia, CAN9848MCovington Aircraft Engines Inc · Okmulgee, OKN9848TMueller Scott A · Garden Prairie, ILN9848VSuperhawk Flight LLC · Plano, TXN98492Henry Mark Alan · Dickinson, TXN98494Noggle William L · Warthen, GAN9849AWatters James · Dwight, ILN9849C377 Morale Welfare Recreational Services Aero Club · Albuquerque, NMN9849GPray Aviation Inc · Augusta, KSFirst renewal noticeN9849HSouthwest Plane Holdings LLC · Kalispell, MTN9849LDynasty Adventure Inc · Wilmington, DEN9849QBriggs Christopher T · Manchester, NHN9849TRushing Kevin W · Marks, MSN984FAFreedom Aviation Inc · Lynchburg, VAN98502Sky Warrior Flight Training Inc · Pensacola, FLN9850VPropability One LLC · Daytona Beach, FLN9851ARhoads Michael C · Ketchikan, AKN9851CDodson International Parts Inc · Rantoul, KSN9851HCivil Air Patrol Inc · Montgomery, ALN9851JPlanepower LLC · Meridian, MSN9851XWheeler Andrew C · Orting, WAN98525Trns Solutions LLC · Lewes, DEN9852CRyco LLC · Lusk, WYN9852JG & M Associates LLC · Quitman, GAN9852TRead Colin L · Plattsburgh, NYN98530Swan Aviation Ministries Inc · Crestview, FLN9853COregonian Flying Club · Wilmington, DEN9853GParker Steve E · Palmer, AKN9853HMiles Alexander Bevans · Columbia, SCN9853JEastern Kentucky University Center For Aviation · Richmond, KYN9853LTrend Vector Aviation Int · Barrigada, GUN9854ASchlichar James C · Austin, TXN9854JAdams James P · Wilbraham, MAN9854TMcdowell Bryan D · Blooming Grove, TX
Back to AD 87-20-03 R2