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.
N700SEBooze Conrad C · Warner Robins, GAN700SNAerospace Trust Management LLC Trustee · Wilmington, DEN700TCTek Aire LLC · Blacklick, OHN700TEAustin Bill DBA · Sparta, TNN700VWCondor Aviation LLC · Bethlehem, PAN700WGNeuro Endovascular Services And Technology LLC · Palm Harbor, FLN700WPLebus Jack G · Longview, TXN700WZPinto Robert · Sicklerville, NJN700YMKisthard James · Roberts, MTN700YPDelta Delta LLC · Fargo, NDN700YWHorwath Ricky N · Saint James City, FLN7010BDurfee Tristan O · Duluth, MNN7010FEconomou Michael · Falls Church, VAN7010GStavair LLC · Gulf Breeze, FLN7010PJuliett Tango LLC · West Rutland, VTN7010QMosman Matthew J · Nezperce, IDN7010SNass Michael F · Clinton, IAN7010VCompass Aviation Maintenance LLC · Shelby, NCN7010WBrown Nicholas R · Knoxville, TNN7010YBrown William C Jr · Northville, MIN7011BFuller Eddy A · Madras, ORN7011DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LAN7011GChase Development Aviation LLC · Oakland Park, FLN7011JSouthlake Aviation LLC · Arden, NCN7011PJapikse Bert · Pawleys Island, SCN7011WLevine Allen D Trustee · Goshen, NYN7012DBarlow Jason P · Brighton, CON7012RPalomo Joe · Laredo, TXN7012YBooher Greg F · Livingston, TNN7013GSaeid Abdelmasih · Euless, TXN7013PShumock Craig A · Moss Point, MSN7013QVeil Casey J · Jamestown, NDN7013VForsman Robert J · Yelm, WAN7013YHubbard James E · Dover, OHN7014PRyan John David · Fort Rucker, ALN7014WSpi Group LLC · Georgetown, TXN7014ZBarrett Jane T · Tehachapi, CAN7015Woods Donald E · Great Falls, MTN7015GDaugherty William A · Horseheads, NYN7015WHunt Timothy J · Mesa, AZN7016BUnable Direct LLC · Kalispell, MTN7016FNations One For Christ · Duluth, MNN7016GRocky Air LLC · Cheyenne, WYN7016PSgroi Eric A · Wentzville, MON7016VHotel Charlie Aero LLC · Marshville, NCN7016WDoorenbos Rodney J · Washburn, MON7017PDewey J Levie P C · Chino Valley, AZN7017QClair Michael A · Omaha, TXFirst renewal noticeN7017RRd Aire LLC · Opelika, ALN7017VHenry R Rey Ltd · Fresh Meadows, NY
Back to AD 87-10-06 R1