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.
N65JHJee Derrick W · Fort Walton Beach, FLN65JSCall One Inc · Clarinda, IAN65JTBlohm Jorge Tomas · Mooresville, NCN65KDNorthwest Wings LLC · Hillsboro, ORN65KFCrestwood Aviation LLC · Schererville, INN65KKExperimental N65kk LLC · Little Rock, ARN65MMShewbart Keith M · Crystal River, FLN65MRAtarah LLC · Tucson, AZN65NPWilson Stuart L · Glenpool, OKN65NURanard Douglas R · Dugger, INN65PHMuetzel Michael P · New Port Richey, FLN65PPAir-Supply Aerial · Philomath, ORN65PSEastern Stearman Inc Trustee · Leesburg, VAN65RJAdvantage Flight Training And Services LLC · Warren, ARN65SAAkin & Son Inc · Texarkana, TXN65SCDocs Air LLC · Buffalo, WYN65SDBlankenship Royce J · Daytona Beach, FLN65SGMacdonald Gerald C · Oberlin, OHN65TKReally Inc · Orange Park, FLN65TXMitchell David Lamar · Ashdown, ARN65WAWoolse Duane L · Salt Lake City, UTN65WMWilson Thomas L · Texarkana, TXN65XXWeidenbaum James M · Boerne, TXN65ZMReinschmidt John S · Lakeway, TXN66005Slp III 1 LLC · Columbia, MON6600PParker Matthew M · Mesa, AZN6600RDoyles Welding Lc · Phillipsburg, KSN66015Rock Solid Aviation LLC · Lake Charles, LAN66018Executive Aviation LLC · Peoria, AZN6601HCanby Pilots Club Inc · Canby, MNN6601JRobinson John H · Kernersville, NCN6601KAir Force Academy Aero Club · Usaf Academy, CON6601LUnited Jet Sales Inc · Newark, DEN6601RHolmes Donald R · Carlsbad, CAN6601WAircraft Guaranty Corp Trustee · Oklahoma City, OKN66023Bravo Aero LLC · Concord, NCN66029Wpf Air LLC · Fort Myers, FLN6602DLand Of Liberty LLC · Seminole, FLN6602ERivera Joel · Carolina, PRN6602HOver The Mountain Aviation LLC · Calera, ALN6602JD14 Flight Club Inc · Manteno, ILN6602PBertrand Paxton A · Melbourne, FLN6602RFagundes Farms · Hanford, CAN6602YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN66038Landrum Erik G · Austin, TXN6603JWorkman Karen L · Northfield, MNN6603PHales Kurt A · Washington, UTN66049Aerosync LLC · Miami, FLN6604EFlyn High Aviation LLC · Boynton Beach, FLN6604FEvolution Air LLC · Huntley, IL
Back to AD 87-10-06 R1