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.
N93196Registration Pending · Lafayette, LARegistration pendingN9319AMyers Alan J · Danville, ILN9319HHoffman Stanley L Jr · Bethel, AKN9319UJohnson Douglas G · Mason City, IAN9319XShepherd Joseph R · Fayetteville, GAN931EMClackamas County Sheriffs Office · Oregon City, ORN931MSColeman Aviation LLC · Livingston, TNN931URRegistration Pending · Ivins, UTRegistration pendingN93202Nature State LLC · Portland, ORN9320CRiley Coda L · Beaumont, TXN9320DDodson International Parts Inc · Rantoul, KSN9320GChiles Farms LLC · Hooper, CON9320HPlane Tail LLC · Bethany, CTN9320RHaskell Flyers LLC · Sublette, KSN9320XBlue Skies Air LLC · Portland, ORN93214Sundance Air Services Inc · Alameda, CAN93216East Moriches Aerial Advertising Ltd · Ridge, NYN9321BGippner Gerald W · Olathe, KSN9321EMertinez Matos Daniel Enrique · Fajardo, PRN9321GFontana Michael A · Kirkwood, MON9321XSakonnet Aircharter · Bradenton, FLN93229Back Country Club LLC · Crawford, TXN9322ALeamon Douglas H Trustee · Stockwell, INN9322CWaters David J · Phelps, NYN9322GHutchinson Darrold Trustee · Hingham, MTN9322XCivil Air Patrol Inc · Maxwell Afb, ALN93239Minuteman Aviation Inc · Missoula, MTN9323BCarter Lance F · Bangor, CAN9323ESchock Richard F II · Peoria, ILN9323XBertelsen Sven Erik · Gulfport, FLN9324ABoswell Kurt R · Renton, WAN9324CWillig Zachary · Angola, INN93251Flaherty Edward T · Scotia, NYN9325ABarron Aviation LLC · Perry, MON93260Webb Michael · Magnolia, TXN93262Land Office LLC · Burlington, CON93263Xin Han Aviation LLC · Atwater, CAN93264Wolfe Michael S · Norco, CAN93267Cachorro Cattle Co · Granbury, TXN9326DAll Seasons Aviation LLC · Laredo, TXN9326EWest Bend Air Inc · West Bend, WIN93271Pauma Holdings LLC · Colorado Springs, CON93272Grossman Marc · Lake Oswego, ORN93274Wltf LLC · Caldwell, IDN93276Fitzgerald Robert Paul · Eagle River, AKN9327ERhoades Christine · Laguna Beach, CAN9327XHull Ray · Waynoka, OKN93281Bishop Mike · Rifle, CON93285Corrie Brent · Vero Beach, FLN9328BDethlefs Darrell C · Mechanicsburg, PA
Back to AD 87-20-03 R2