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.
N737QHPhilbrick Rodney C DBA · Bishop, CAN737QLRegistration Pending · Calabasas, CARegistration pendingN737QPStarlin Air LLC · Crawfordsville, INN737QRClark Walter · Denver, NCN737QXFirst Eclipse Ltd · Richmond, VAN737RMassad Sam I · Brunswick, GAN737RADodson International Parts Inc · Rantoul, KSN737RDMahoney John Trustee · Boise, IDN737RECroutch Marvin L · Encino, CAN737RGThomas Troy A · Hastings, NEN737RLGeneral Aviation LLC · Henderson, NVN737RNFife Aire LLC · Newnan, GAN737RPElevated Aviation LLC · North Charleston, SCN737RQHughes Stephen E · Danbury, CTN737RRMindy Limited LLC · Muscatine, IAN737RTFeather Worx Aviation LLC · Bonita Springs, FLN737RVBalaska Mark A · Whitestown, INN737RXBuckleitner Eric M · Gaylord, MIN737SAN737sa LLC · Lantana, FLN737SBCothren Graff Smoak Engineering Inc · Shreveport, LAN737SCIsely Alec D · Monroe, WIN737SDBreidenthal Robert E · Seattle, WAN737SHWysong Henry D III · Kent, WAN737SJOracle Aviation LLC · Omaha, NEN737SRAbove The Haze LLC · San Lorenzo, CAN737SUSkypark Aviation LLC · Bountiful, UTN737SVPage Flying Club Inc · Page, NDN737SXRoudebush Kevin L · Salem, ORN737SZPeres John Patrick · Portland, ORN737TAThomas Gregory Shan · El Paso, TXN737TBBartholemy Construction Inc · Beaverton, ORN737TCFlyboys Nevada LLC · Henderson, NVN737TDJarvis Jeffrey S · Portland, ORN737TEJohn P Kintzle LLC · Mount Prospect, ILN737TFThrifty Comercio Inc · Austin, TXN737TJStanislaus County Sheriffs Department · Modesto, CAN737TMLiberty Aviation LLC · Henderson, NVN737TQN737tq Aviation LLC · Sheridan, WYN737TSSeven Tango Sierra LLC · Yuma, AZN737TXCalifornia In Nice Inc · San Jose, CAN737TYTexins Flying Club · Mckinney, TXN737TZNickell Alan L · Rigby, IDN737UAAlternate Air Inc · Seattle, WAN737UBMeyeres Farms LLC · Chase, KSN737UEHostler Susan L · Bradfordwoods, PAN737UFHeart Of Texas Aviation LLC · Troy, TXN737UKAlternate Air Inc · Seattle, WAN737ULMelbourne Flight Training LLC · Melbourne, FLN737URSky Warrior Flight Training LLC · Pensacola, FLN737UYFlycarolina LLC · Concord, NC
Back to AD 87-10-06 R1