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.
N74964Air Dakota Flite Inc · Hettinger, NDN74967Owens Sara R · Casper, WYN74968Niesen Isaac W · Nikiski, AKN7496DLeggett Brandon · Eola, TXN7496PS & S Air Inc · Wilmington, DEN7496SSmith Linda L · Port Charlotte, FLN74972H&H Aircraft LLC · Grey Eagle, MNN74979Johnson Warren E · Kenai, AKN7497PLift Aircraft LLC · Carmel, INN7497TLeffler Greg L · Zion Crossroads, VAN7498JSawyer Steven A Md · Hampton, GAN7498PKarnegis Frank J · Senoia, GAN74990Berry Stanley W · Reddick, FLN74996Seward Air Taxi LLC · Seward, AKN74998White Jacob E · Delta Junction, AKN7499PTri-C Farms · Tompkinsville, KYN7499RCart Caleb L · Eunice, LAN7499WWoodward Adam B · Fort Collins, CON749CCOtto David L · Lacey, WAN749CSBower John M · Santa Cruz, CAN749DWAntler Aviation And Wildlife Service LLC · Wasilla, AKN749JFFrazee John F · Fabius, NYN749MCWilliams Rodger Gale · Broseley, MON749PASkywest Leasing Inc · St George, UTN749PCGreen Hornet Aviation LLC · Washington, DCN749PJAgl Aviation And Management LLC · Payson, AZN749SKOcean Aerial Ads Inc · Berlin, MDN749TMKeithley Thomas E · Pueblo, CON749TWTumbleweed Leasing Co Inc · Salt Lake City, UTN749VWGenet David S · Saint Augustine, FLN74ABAerial Digital Images LLC · Huntington Beach, CAN74ALDavis Tessie · Buckeye, AZN74ATGelvin Stanley M · Central, AKN74BBHy Aviation LLC · San Juan, PRN74BFSellers Jim M · Watkinsville, GAN74BGReliance Aviation LLC · Mendon, NYN74BMAlexander City Aviation Corp · Alexander City, ALN74BNBig Bend Community College Foundation · Moses La, WAN74CPersonal Aviation Inc · Poway, CAN74CDMcburney & Associates LLC · Horseshoe Bay, TXN74CNBuckley Scott · Orcutt, CAN74DBSanderson Bryan D · Eagle, IDN74DCCoburn Toni · New York, NYN74DDN74dd Inc · Apalachicola, FLN74DJWood Shawn A · Cassville, WIN74DMT C Rian Association LLC · Grove, OKN74DNMooney Daniel P · Edmond, OKN74DPRegistered aircraftN74DVRegistered aircraftN74EPCantrell Grady DBA · Los Banos, CA
Back to AD 87-10-06 R1