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.
N7462WResidential Inspection Services Inc · Sun City Center, FLN74630May Michael J · Blue Ridge, GAN74631Galactic Xtreme Enterpises · Madison, ALN74633N74633 LLC · Blue Ash, OHN74636Semitis LLC · Deland, FLN74637Equipment Leasing & Rental Inc · Wilmington, NCN74639Ford Edward J · Newtown, PAN7463BShannon Brian S · Katy, TXN7463DRaising Cain Farms Partnership · Leland, MSN7463FWendling Mark A · Bryant, SDN7463JUnusual Attitudes LLC · Bates City, MON7463RBrezina Douglas · Hines, ILN7463VHarper Abe L Jr · Daphne, ALN7463WMarschall Travis T · Culver, INN7463YSkyway Flight Service LLC · Jonesboro, ARN7463ZTreasure Coast Soaring Club · Port Saint Lucie, FLN74640Jensen Leonard · Pasadena, CAN74641Hortman Walter J · Warminster, PAN74642Peterson Thomas · Owatonna, MNN74643Mohler Earl C · Bonita, CAN74644Ice Kevin F · Rock Hill, SCN74645Cain Paul · Prunedale, CAN74646Santa Barbara Flying Club · Goleta, CAN74647Nelson Brett W · Louisville, KYN74648Gasowski James A · Apollo, PAN7464BAviator Ppg LLC · Lake Wales, FLN7464LNorth Wind Air Service LLC · Seattle, WAN7464VSpaeth Roger P · Roseville, CAN7464WBabcock Wayne N Trustee · Albuquerque, NMN74651Echo Foxtrot Holdings LLC · Midway, UTN74655Yankee Aviation Services Inc · Plymouth, MAN74657Janak Russell G · Belton, TXN7465FSmith Norman L · Houston, TXN7465GLaird Charles A · West Chester, PAN74660Lein Bobby D · Winchester, VAN74663Los Cazadores Aviation LLC · Cut Off, LAN74664Pepitone Dave · Santa Fe, NMN74665Kagan Perry M · San Marcos, CAN74666Edmundson George · Hood River, ORN7466PJmj Aviation LLC · Kalispell, MTN7466VBaker Ronald James · Queenstown, MDN7466WCooper Tracy V · Little Rock, ARN74670Smith Charles A · Natick, MAN7467BEllis Matthew D · Park City, UTN7467JDouble Bridges Aviation · Enterprise, ALN7467LNewton Darin A · Eagle River, AKN7467RGee Greg · Los Angeles, CAN7467WPlane Krazy LLC · Edina, MON74682Tiger Garb LLC · Stanton, MIN74684Blue Eagle Aviation LLC · Nazareth, PA
Back to AD 87-10-06 R1