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.
N91451Pettus Const Inc · Dallas, GAN9145AWomack Wilbur A Jr · Jackson, LAN9145CReitz Andrew P · Pembroke Pines, FLN9145GYost James J · Placentia, CAN9145USharp Wayne H · Mena, ARN91464Breard Armand C · Monroe, LAN9146AHusser Marilyn G · Independence, ORN9146GShea Bernie J · Polson, MTN9146MJc Aircraft Leasing LLC · Wasilla, AKN9146XMangun Charles L · Middleton, IDN91470Sky Sailing Inc · Warner Springs, CAN91475Johnson Robert L · Douglas, AKN91476Petersen Greg · Chelan, WAN9147BReed Zane · Mountain Home, IDN9147CCope Eric E · Angels Camp, CAN9147GSnyder Barry L · Morrison, CON91484Scovel Simeon Edwin · Ontario, CAN91489Dan River Aero Club Inc · Jonesville, NCN9148MBlackhole Inc · Round Rock, TXN9149BFoust Kal E · Lenox, MIN9149CBryan Robert G · New Lenox, ILN9149MBoynton Scott E · Campbell Hall, NYN914AVNorcal Skydiving LLC · Cloverdale, CAN914AZN969az LLC · Miami, FLN914CBChan Blair H · Arlington, TXN914EYDreimiller Raymond J Jr · Bloomfield, NYN914FCSinibaldi Glenn · Highland Park, NJN914HSHis Wings Air Service Inc · Hyder, AKN914JDAis Wings LLC · Grand Rapids, MIN914MDCrum Brian B · Warrensburg, MON914RRMartinez Jeff L · Lewistown, MTN914STAir Ex LLC · Chelan, WAN914ZSkylens LLC · Hammond, LAN91507Eagle Aviation LLC · Spearfish, SDN91508Stewart Bryan P · Carson City, NVN91509Watts Timothy R · Hermiston, ORN9150BHarral Blake · Prescott Valley, AZFirst renewal noticeN9150CAkers Joel W · Anchorage, AKN9150HN9150h LLC · Charleston, SCN9150MSkyler Aviation Inc · San Diego, CAN91510Registration Pending · Eagle River, AKRegistration pendingN91513Attactix Aviation LLC · Tucson, AZN91515Bulkley Gregory A · Spokane, WAN9151HFirst Flight Corp · San Diego, CAN9151MMcatee Kevin Patrick Trustee · Ventura, CAN9151UAdvanced Aviation LLC · New Century, KSN91529Dutchess Community College · Poughkeepsie, NYN91538Graves Dale E · Waukesha, WIN9153BMires James · Newnan, GAN9153CPax Enterprises Inc · Allen, TX
Back to AD 87-20-03 R2