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.
N816GHolland Travel Air LLC · Holmen, WIN816GMAtd Pilot Training LLC · Kansas City, MON816HAAtp Aircraft 4 LLC · Wilmington, DEN816JHIndy Aviation LLC · Carmel, INN816JPKnox James P · Park Rapids, MNN816KCCrews Kevin S · Winter Haven, FLN816LRegistration Pending · Anderson, SCRegistration pendingN816LGGray James · Jupiter, FLN816LLAero Equities LLC · Ventura, CAN816RARochester Air Center LLC · Canandaigua, NYN816RCSerani Enterprises LLC · Broomfield, CON816RFTerhaar Ronald D · Albany, ORN816RMRegistered aircraftN816STForensic Doctors Group Pc · San Francisco, CAN816TSCd Logic Inc · Wilmington, DEN816TXDavis Derek P · Sebastian, FLN816WAFredericks Ruth · Miami, FLN816WBNorthern Aggregate Inc · Bemidji, MNN816WMRent A Copter LLC · Homer Glen, ILN816WRDonovan Mark J DBA · Moultonborough, NHN816YQazwbt LLC · Arroyo Grande, CAN816YPB&D Air Solutions LLC · Austin, TXN8170CGibbens Brett S · Mc Grath, AKN8170FAlfonso Peter J · Jamestown, RIN8170NFalter George H III · Baltimore, MDN8170SSkywagons.Com LLC · Placerville, CAN81713Brown Matthew · Spokane, WAN81715Registration Pending · Hanford, CARegistration pendingN8171DLueking Clyde F · Holdrege, NEN8171NOndrovic Rick · Belton, SCN8171WAnderson Christopher J · Ogden, UTN8171YFaith Works Aviation LLC · Glenmoore, PAN8172Magrini Shawn P · Salem, OHN81723Aero Legacy Foundation · Basehor, KSN81729Bushroe Dennis J · Temperance, MIN8172CDrath Mark O · Reedsville, WIN8172NBeasley Michael Jeffrey · Dothan, ALN8172PRemarkable Resources LLC · Bristol, WVN8172QFrost Aviation Services Inc · Las Cruces, NMN8172WMile High Advertising LLC · Dover, DEN8172YKline John C · Wolcottville, INN8172ZAverka Steven D · Sutton, MAN8173DAaa Flying Service Inc · Wellington, TXN8173ESky Equity LLC · Woodbury, MNN8173HMcmahon Mary G · Winchester, CAN8173NJones Roy F · Benson, AZN8173PLao Investments LLC · Meeker, CON8173WRoadrunner Flight School LLC · Farmington, NMN8173YAltitude Aviation Group LLC · Kissimmee, FLN81741Corsican Aviation LLC · Westfield, IN
Back to AD 87-10-06 R1