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.
N903KSMbk Leasing And Consulting LLC · Lakeland, FLFirst renewal noticeN903NSAmerican Patrols Inc · Midland, TXN903SASunrise Aviation Inc · Ormond Beach, FLN9040CTexas Skyways Inc · Boerne, TXN9040XAcme Air Venture Inc · Bristol, WIN90419Goodhue Clinton H · Sidney, MEN9042HSt Pete Aviation Services LLC · St Petersburg, FLN9042QTumbleweed Leasing Co Inc · Salt Lake City, UTN9042TCase Rod E · Gold Hill, ORN90432Knutson Wayne R · Thompson, NDFirst renewal noticeN9043CHemphill Holdings LLC · Hemphill, TXN9043HPinter Seth K · Abbotsford, WIN9043XKruger Bruce W · Gustavus, AKN9044MOlsen Dale B · Wasilla, AKN9045GSkyview LLC · Omaha, NEN9045MCunningham Bill · Tulsa, OKN9046CSherwood David R · Porterville, CAN9046FCenturion Aviation LLC · Lewes, DEN9047GOdd Dale R · Aberdeen, WAN9047MOlsen Scott · Forest Lake, MNN9047XKelley Ronald C · Deer Lodge, MTN9048AGrady Keith L · Phoenix, AZN9048HGravesen Mark A · Kenmare, NDN9048MFurber David E · Anchorage, AKN9048TNardi Greg · Missoula, MTN9048XK Fortner LLC · San Marcos, TXFirst renewal noticeN9049CLanese Matthew N · New Milford, CTN9049GSmokey Bay Air Inc · Homer, AKN9049MPrivate Aero Group LLC · Wilmington, DEN9049TMeszaros David · Nashport, OHN904BPPlane Fun Inc Tr Trustee · Snellville, GAN904FKJax Beach Aviation LLC · Jacksonville, FLN904PWJax Beach Aviation LLC · Jacksonville, FLN904RAJw Aero Holdings Inc · Canandaigua, NYN904SWAmerican Gp Inc · Nashville, TNN904WADelarosa Sergio Miguel · Miami, FLN9050GOneal Gary L · Springdale, ARN9050XClassy Cockpits LLC · Ham Lake, MNN9051GMid Continent Aircraft Corp · Hayti, MON9051MGrant Rory C · Lincoln, NHN9052MJones Victor E · Cordova, AKN9053AN292ac Flyers LLC · Brandon, MSN9053CGuthrie Matt W · Corrales, NMN9053XI Buy U Fly LLC · Prescott Valley, AZN9053ZTjossem Martin O · Paullina, IAN9054CDunlap Joseph A · Brainerd, MNN9054MMuxworthy Neil W · Hamilton, TXN9054NBement Bob H · Vale, ORN9054XKnowles Charles M Jr · Chapmanville, WVN9054ZAeronautical Educational Foundation · Stockton, CA
Back to AD 87-20-03 R2