AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-R1')
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-10-06-R1')
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-10-06-R1') 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-10-06-R1') 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.
N84898Coles County Airport Authority · Mattoon, ILN8489DStrub Henry J · Dillingham, AKN8489LBarlow Warren P · Madison, ALN8489RPatriot Aircraft Leasing LLC · Erie, CON8489WJayroe Clinton Walter · Germantown, TNN8489YSorbi Aviation Inc · El Cajon, CAN848AAAb Prop Plane I LLC · Metairie, LAN848DJMahc Properties LLC · Cedar Key, FLN848DWWeisgerber David S · Ionia, MIN848GFGunning Craig H · Lansford, NDN848KFFelder William D · Dallas, TXN848MAIcarus Flying Academy LLC · Farmingdale, NYN848PWagoner Teddy J · Mebane, NCN848RVGetz Christopher M · Hellertown, PAN848TLoggerhead Reef Aviation LLC · Jupiter, FLN848TCTexas State Technical College · Waco, TXN848TDKrugh Patrick M · Show Low, AZN848VBBabyak Victor J · Punta Gorda, FLN848ZWitt Phillip D · Roanoke, TXN84901Boerne Flight Options LLC · Boerne, TXN84907Wang Qiuyuan · Arcadia, CAN8490DLittle Big Horn Co · Prescott, AZN8490LMgg Aviation 2025 LLC · Annandale, MNN8490RSimecek Glen D · Kirkland, WAN8490YGolden Eagle Outfitters Inc · Delta Junction, AKN8491AAarow Aircraft Leasing LLC · Dallas, TXN8491CTarleton Aaron Rayce · Salem, ALN8491DDirty Side Down LLC · Downers Grove, ILN8491FRutherford Robert E · Maryville, TNN8491LDeb Air Inc · Norcross, GAN8491RDarnell Benjamin F Jr · Sevierville, TNN8491WMunson Justin M · Augusta, GAN8491YRollman Levi S · Wasilla, AKN8492FVintage Wings Aircraft LLC · Centerpoint, INN8492LCarey Thomas A · Carabaset Vly, MEN8492PKovacevich Rudy · Fowler, OHN8492WMoore Myron Keith · Amarillo, TXN8492YGaipa Timothy A · Saint Joseph, MIN8493CPlante Matthew · Blackstone, MAN8493FCharles City Aeronautics Inc · Charles City, IAN8493LBriss David S Dmd · Somerset, NJN8493RCapital City Flyers LLC · Thomasville, GAN8494DKincaid Jonathan A · Frankfort, MEN8494FPlane Viewing LLC · Colbert, WAN8494LHess Garrett · Fullerton, CAN8494RCactus Air Gold LLC · Mesa, AZN8495CMtl Inc · Sparta, TNN8495FKing Robert M · Fall River Mills, CAN8495WSensenig Landis · Owen, WIN8496FSoriano Juan H · Travelers Rest, SC
Back to AD 87-10-06 R1