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.
N91170Paklook Air Inc · Bethel, AKN9117BPartridge John R · Manchester, NHN9117CRegistered aircraftN9117GAndrews Mimi Muldrow · Hilltop Lakes, TXN9117MPettigarrett LLC · Manchester, GAN9117TMichaud Paul K · Forest Lake, MNN9117UBahr Timmy A · Crandon, WIN91183Hatch Hyrum G · Gilbert, AZN9118BCulpeper Aviation LLC · Queen Creek, AZN9118CWalter Tina R · Yorkville, CAN9118THagen Bruce L · Reeder, NDN9118U9118u LLC · Dover, IDN91190Renfro Michael W · Bethel, AKN91199Olmstead Daniel H · Kimberly, IDN9119ATorraca Peter · New York, NYN9119GWinters Richard Linn · Chandler, AZN911ATW I F A (Washington International Flight Acad) LLC · Gaithersburg, MDN911BWOlsen Garry O · Forest Lake, MNN911EWeiss Elliott · Fresno, TXN911JTSchaefer Kent M · Anacortes, WAN911MCKing Daddy Aviation LLC · Madison, MSN911MDAirplex Aircraft LLC · Springfield, MON911PBaldwin Andrew W · Lander, WYN9120CFrison Joseph · Milton, WIN9120GRoderi Air LLC · Berlin, MDN9120HKrieg Kristi · Tonasket, WAN9120XStevens Matthew J · Onaway, MIN9121CBowser Justin · Colorado Springs, CON9121HTwenty-One Flyers Inc · Norwalk, CTN91220Wall Christopher Kenneth · Rochester, NYN91221Marvin Ray · Tomahawk, WIN91223Taylor James R · Murfreesboro, TNN91224Peninsula Aero Technology Inc · Kenai, AKN91225Woodaman James G · Pasadena, CAN9122CJohnson Joseph S · Eagle River, AKN9122TWerth Lance C · Johnson Lake, NEN9122XBissell Lee G · Culver, ORN91230Cutting & Sektnan Inc · Mcminnville, ORN91231N91231 LLC · Columbia, MON91236Skylane 73 LLC · Altadena, CAN9123ASale Reported · Draper, UTSale reportedN9123BStockton Clifford A · Anchorage, AKN9123CRegistration Pending · San Bernardino, CARegistration pendingN9123HTwenty Three Juliet LLC · Tyler, TXN91245Delmonte Paul R · Mountain Green, UTN91249Sutton Aircraft Salvage LLC · Palmer, AKN9124AWest Kevin B · San Antonio, TXN9124BRegenold John A · Saint Paul, MNN9124USmith Stanley P · Athens, ALN9125CHafen Aviation Group LLC · Pasadena, CA
Back to AD 87-20-03 R2