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.
N756SENotus LLC · Winfield, KSN756SWSale Reported · Basom, NYSale reportedN756TBTrehus Eric M · San Jose, CAN756TCHazelrigg Geoffreya · Chalfont, PAN756TKG & M Aircraft Inc · Wheat Ridge, CON756TLMichael Maiden LLC · Sandy, ORN756TRSawyer Charles W · Marstons Mills, MAN756TUMehr David L Trustee · Mesa, AZN756UBSayer Wayne · Bishop, CAN756UCJohnsen Ronald R · Des Moines, IAN756UE756ue LLC · Kalispell, MTN756UHMiller Justin · Big Sky, MTN756VHCondair Flyers Inc · Latham, NYN756VSMystery Air LLC · Walker, LAN756WRegistered aircraftN756WAVeil Keith A · Jamestown, NDN756WEJames F Barnes · Laguna Niguel, CAN756WVMr Cake LLC · Missoula, MTN756WWLockwood William A · Okanogan, WAN756XFWeaver Michael L · Leawood, KSN756XMYounan Dalour · San Diego, CAN756XPMorton James D · Littleton, CON756XWMid-America Communications Inc · Pocahontas, IAN756YLTwo Ten LLC · Joshua Tree, CAN756YMCrane Charles · Muskogee, OKN756ZCSkinner Leasing LLC · Medford, ORN756ZLPerformance Aircraft Sales Inc · Lincoln, NEN756ZNMills James P · Chadds Ford, PAN756ZYChapa Jana K · Corpus Christi, TXN75701Roseville Aviation LLC · Roxboro, NCN75704Lanning 1 Aviation LLC · Amarillo, TXN75706Morey Airplane Company Inc · Middleton, WIN75709Newsom Richard W · East Bend, NCN7570FReichelt Christopher M · Mocksville, NCN7570JHubbard David L · Earlville, ILN7570PKraule Ernest O · Saratoga, CAN7570WWatkins Andrew B · Redding, CAN7570YJackson Rex A · Granbury, TXN7570ZKingsley Kiman J · Miller, MON75710Cox Leon F · Ruffin, NCN75711Falcon Air LLC · Anchorage, AKN75712Hill David Ryan · Palm City, FLN75714Lincoln Skyways Inc · Lincoln, CAN7571GCook Thomas B · Boston, MAN7571PScribner George W · Suffolk, VAN7571TKillebrew Elizabeth Morrigan · Round Rock, TXN7571WCox Kevin D · Draper, SDN7571YPipers Are Still Better LLC · Carson City, NVN75721Propell Air LLC · Deridder, LAN75722Pt Real Estate Inc · Port Hadlock, WA
Back to AD 87-10-06 R1