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.
N957DFNorthern Flight Expeditions LLC · Hopkins, MNN95801Abraham James · Johnson City, TNN95802Aircraft Acquisitions Inc · Durham, NCN95807Prostar Flight Services LLC · Bozeman, MTN95808Cape Cod Aero Club LLC · Falmouth, MAN9580BEds Flying Service Inc · Denton, MTN9580XNewman Michael Mcdermott II · Campo, CAN9581ADean Jeffrey · Husum, WAN9581HCole Jimmie D · Cotopaxi, CON95821Kent State University · Stow, OHN95826Mountain Air Inc · Ducktown, TNN9582HMiller Timothy · Saratoga, CAN9582MAmerican Aviation Inc · Woods Cross, UTN9582VCady Craig D · New Braunfels, TXN95831Space Coast Aircraft Co · Merritt Island, FLN95834Herschend James R · Ozark, MON9583BBurke Larry Ryan · Pembroke, GAN9583MUsda Aphis Ppq · Edinburg, TXN95840Lane Community College · Eugene, ORN95841Para David B Trustee · Prescott, AZN95848Makowski Maciej J · Nipomo, CAN9584APenca Stephen J · Arlington, TXN9584B360 Marine · Bristol, RIN9584TBruce Nicholson · Gallup, NMN9584VStick & Rudder Club Inc · Waukegan, ILN95857A & M Airplane LLC · Grover Hill, OHN95858Tucker Thomas O Jr · Austin, TXN9585GBillmyer Services Inc · Friday Harbor, WAN9585VHarrington Aviation LLC · Scarborough, MEN95860Cumberland Air LLC · Stuart, VAN95863Shields Stephen T · Holly Springs, NCN95865Registered aircraftN95868Descco Design & Construction Inc · Fleetwood, PAN9586BAmidon Gary · Shady Cove, ORN9586TRegistration Pending · Talent, ORRegistration pendingN9586XMclenaghan Alvin N · Phoenix, AZN95879P3 Aviation LLC · Austin, TXN9587VPinnick Brent E · West Baden Springs, INN9587XFulminare Aviation LLC · Ocala, FLN9588ADehaven James R · Frisco, TXN9588BSmith Timothy E · Anchorage, AKN9588VKachemak Bay Flying Service Inc · Temple, TXN9588XHanson Roger D · Seattle, WAN95897Fisher Thomas F · Olalla, WAN9589AVercoe Jeffrey B · Lincoln, MTN9589GKinate Mike · Colorado Springs, CON9589HFryar Scott D · Starke, FLN9589XFishel Thomas N Trustee · Reno, NVN958BCBranson William E · Mooresville, NCN958JRReimel Joseph Jr · Salem, NJ
Back to AD 87-20-03 R2