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.
N845DClub Cherokee Inc · Crystal, MNN845DTKilo Delta Ventures LLC · Porter, OKN845EDBainbridge John Allen Jr · Weed, CAN845GArcher Flight LLC · Wilmington, DEN845MAN845ma Aircraft Leasing LLC · Lehi, UTN845RFDibenedetto Christian Walter · North Plains, ORN845RV88 Romeo Vans Rv LLC · Austin, TXN845SHBuell Travis Wayne · Harper, TXN845TCTexas State Technical College · Waco, TXN846Davis Hedley C · Middletown, DEN84602N84602 LLC · Greensboro, GAN84604Sky Aviation Corp · Staten Island, NYN8460CState Of Alaska Dept Of Fish & Game · Kodiak, AKN8460RVenuto Andrew · Las Vegas, NVN8460WRain Ricardo · Ellicott City, MDN8460YOmarco LLC · Woodbridge, VAN8461CKnot Grounded LLC · Treasure Island, FLN8461LScott Gerald D · Fieldon, ILN8461USfb Aviation Services LLC · Edmond, OKN8461WHernandez Luis A · Longview, TXN84625Our Archer LLC · Rindge, NHN84628Flying W Enterprises LLC · Shelton, WAN8462CFrack Jason M · Northampton, PAN8462DBarrett William G · Portland, ORN8462NBoskind Richard · Indialantic, FLN8462WLazear William Randolph · Springfield, VAN84633Eckhardt Bridget A · Chugiak, AKN84634Johnson Marty C · De Berry, TXN8463JMission Aircraft LLC · Friendswood, TXN8463LWings Over Texas Holdings LLC · Denton, TXN8463MPillon Fred L · Oakland, CAN8463TLaco Enterprises LLC · Omaha, NEN8463WLittleton Darrel · Atlanta, TXN8463XRomper Stomper Air LLC · Fort Myers, FLN84642Elder Russell W · Kirbyville, TXN84644Dixon Paul C · Gilbert, AZN84645In The Grey Aviation LLC · Seadrift, TXFirst renewal noticeN84647Falcons Aloft LLC · Friday Harbor, WAN8464DRegistered aircraftN8464JIshawooa Air LLC · Cody, WYN8464RBarbrie Nicholas J · Pittston, PAFirst renewal noticeN8464WWiedemann Shane L · Ridgecrest, CAN8464YTurner Terrance A · Anchorage, AKN84656Mitchell Larry Trustee · Kingsland, ARN84657Myler Mitchell · Bluffdale, UTN84659Laurel Highlands Aeronautical Academy · Latrobe, PAN8465CFlyzone LLC · Mount Laurel, NJN8465DDame Chris A · Harrisburg, ORN8465SFlyzone LLC · Mount Laurel, NJN84662Caverns Consulting LLC · Purcellville, VA
Back to AD 87-10-06 R1