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.
N9284KMtm Aviation LLC · Lake Havasu City, AZN9284MNationwide Aviation LLC · Hudson Oaks, TXN9284PDickinson Malcolm · Stamford, CTN9284STamad Aviation LLC · Tracy, CAN9284VBloomer Garett · Ballston Lake, NYN9284WGutierrez Daniel M · Kennett Square, PAN9284X84x Leasing LLC · Idaho Falls, IDN9284ZFlex Aircraft Leasing Co LLC · Detroit, MIN9285November 9285 LLC · Higden, ARN92855Falcon Flying Club · Mesa, AZN9285CSunset Flights LLC · Azusa, CAN9285HOrion Aviation Aircraft LLC · Carlsbad, CAN9285JCope Jarret C · Lexington, NCN9285M5 M Leasing LLC · Englewood, CON9285PStumpf Bernard L · Westerly, RIN9285QJrb Aviation Ltd · Jasper, GAN9285VEllsworth Bryan E · Garden City, UTN9285YUeeck Brett A · Anchorage, AKN9286Drent Ethan M · Greenwood, INN9286DCaldwell Bob · Columbus, MSN9286FFlying High Like A Bird In The Sky · Longwood, FLN9286MWiley Aviation LLC · Murfreesboro, ARN9286TMccabe Robert C Jr Trustee · Santa Rosa Beach, FLN9286VRupinski Casimir Michael III · Cape May, NJN9286WAmigos Flight Club LLC · Schertz, TXN92873Sonday Terrance P · Spring, TXN92878Jackson Richard L · Indianapolis, INN9287ESkyborne Airline Academy Inc · Vero Beach, FLN9287SDale Michael W · Clayton, NCN9287VRuschman Vaughn M · Boise, IDN92884Bas Part Sales LLC · Greeley, CON92886Lewis John E · Clayton, NJN92888Knudsen Wayne D · Dakota City, NEN92889Miller Andy · Marana, AZN9288BWuest Air LLC · Wilmington, DEN9288JMccormack John P · New Castle, INN9288KCoug Air LLC · Oregon City, ORN9288MHogue Marc A · Tempe, AZN9288PLivingston Jerry D · Wichita, KSN9288RShane Wilson Pa · Fort Myers, FLN9288VMooney N9288v LLC · Fernandina Beach, FLN9288WThut Bruno H · Chagrin Falls, OHN92894Smith Rex H · Fort Bragg, CAN9289CSmallwood Chadwick D · Newnan, GAN9289MUa Aero LLC · Lewes, DEN9289PSvetlik Ludvik Julius · Victoria, TXN9289SThomsen Patrick J · Star Prairie, WIN9289VSteel Richard Allen · Milford, NHN9289WCoffman John H · Polo, ILN928ARGuluzza Gary W · Canyon Country, CA
Back to AD 87-10-06 R1