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.
N8927XSkydive Mid America LLC · Macon, MON8928SFaith Flight LLC · Hopkinsville, KYN8929BB&L Air Inc · Princeton, TXN8929UKrushinski Joseph M · Stafford, VAN8929XDivan Jeremy · Castle Rock, CON892HAInternational Air Services Inc Trustee · Carson City, NVN893012265 LLC · Mercer Island, WAN8930BJohnson Kenneth J · Red Bluff, CAN89310Kuyl Marinus D · Forest Grove, ORN89312Hillsboro Aero Academy LLC · Hillsboro, ORN8931GJordan Robert Nelson · Oakdale, LAN8931TAircraft Partner Holdings Inc Trustee · BerlinN8931VAeroventures 8 LLC · Mt Carmel, TNN8931XBelding Kirk A · Grass Valley, CAN8932VEverett William M · Tuscumbia, ALN89333Chapel Hill Flying Club Inc DBA · Sanford, NCN89337Davis Andrea E · Lake Oswego, ORN8933SHempy David B · Lexington, KYN8933XSnyder Mark · Norwood, CON8934BPennington Clifford H · Mount Washington, KYN8934GCallender Andrew T · Howard City, MIN8934VUniversal Aviators Academy Inc · El Monte, CAN89358Redstone Arsenal Flying Activity · Redstone Arsenal, ALN89359Mccartney Robert · Mountain View, CAN8935GHagouel Yehouda · Reseda, CAN8935MGoldberg Alan N · Point Clear, ALN8935SRegistration Pending · Mesa, AZRegistration pendingN8936BPitman Marvin L · Harrah, OKN8936SWings Over Texas Holdings LLC · Denton, TXN89372Rodriguez Devin · Arlington, TXN89377Bishops' Ltd · Virginia Beach, VAN8937BBradley James M · Fort White, FLN8937GRussin William A · Gurnee, ILN8937VCowden Steven B · Bellingham, WAN8938GTenore William H · Lyons, CON8938SBallou Skies Aviation Inc · Bucyrus, OHN8938UJofredo Corp · Zephyrhills, FLN89390Nevill Jordan J · Ukiah, CAN8939GIms Aviation LLC · Kawkawlin, MIN8939TFeeny Daniel J · Townsend, MTN8939VBray Bradley DBA · North Charleston, SCN893BWLahbak Enterprises LLC · Hilton Head Island, SCN894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeN8940BFlamini Matthew D · Thompsons Station, TNN8940GCapps Christopher N · Austin, TXN8940XKish John · Fort Mohave, AZN8941BBig R Of Greeley Inc · Greeley, CON8941TGeco Inc · Wilmington, DEN8941VSky Castle Aviation LLC · New Castle, INN8941XParrish Perry W · Columbia, KY
Back to AD 87-20-03 R2