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.
N956WBEd Payne Motors Inc · Weslaco, TXN9570BStriplin Bradley H · Pittsboro, NCN9570XGroves Chandler H DBA · Farmington, CAN9571BFarrell Mark A · Omaha, NEN9571HWings Over Texas Holdings LLC · Denton, TXN9571VTempleton John E · Loami, ILN9571XBarnett David Kirk · Brock, TXN95720Stilley John · Flagstaff, AZN95721Copeland Danny K · Roseville, CAN95722Frick Gregory A · Portland, ORN9572GJones Robert D Jr · Chugiak, AKN9572HGeneral Aviation LLC · Henderson, NVN9572LJav Air Services LLC · Anchorage, AKN9572VHill Timothy E · Hooks, TXN9572XSparks James D · Glennallen, AKN95737Kent State University · Stow, OHN9573BDocarmo Aviation LLC · Dallas, TXN9573TLearn To Fly LLC · Portal, GAN9573VReynolds Darryl G · Wills Point, TXN9573XLenyk Michael · Venice, FLN9573ZBangert Richard E III · Seattle, WAN95740Nicholes Steven A Trustee · Portland, ORN95747Eichelberger John Andrew · Winchester, MAN9574BHinds Community College · Bolton, MSN9574GKreiner Kurt · Rch Palos Vrd, CAN9574HJb III LLC · Stuart, FLN9574TMcclellan Fred L · Flint, MIN9574XFlying Nova LLC · Anchorage, AKN9575AConway Sheila R · Seattle, WAN9575GGolden Eagle Outfitters · Delta Junction, AKFirst renewal noticeN9575HBoca Aircraft Partners Inc · Coral Springs, FLN9575VFurnari Alfio · Hutchinson Island, FLN95764Marc Inc · Bolton, MSN95766Ongstad William · Harvey, NDN9576GWerth Lance C · Johnson Lake, NEN9576TDe Vincenzo Chiara · Chicago, ILN9577BRegistration Pending · Scottsdale, AZRegistration pendingN9577VMdr Flying Inc Trustee · Wilmington, DEN9577XColumbia Asset Trust Corp Trustee · Wichita, KSN9577YShort Notice Inc · Pensacola, FLN95785Elton Donald Robert · Kissimmee, FLN95787Wisconsin Aviation - Four Lakes Inc · Madison, WIN95789Katmai LLC · Mount Pleasant, TXN9578BHalseth Harald E · El Paso, TXN9578XTvat LLC · Sun City, AZN95797Kent State University · Stow, OHN9579ABolan Steve A · Concrete, WAN9579EAdventist World Aviation · Wilson, NCN9579XHayden Luke S · Yardley, PAN957CFBergdoll Barry L · Juneau, AK
Back to AD 87-20-03 R2