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.
N91079Gholson Travis R · Carmi, ILN9107CCagle Holdings LLC · Jenks, OKN9107DDelaney Michael J · Grass Range, MTN9107HChm Aviation LLC · Wilmington, DEN9107PLeigh Malik · Pompano Beach, FLN9107SMaul Errol T · Ocala, FLN9107TVaughan Lee E Jr · Philip, SDN9108DJ&P Aircraft LLC · Chugiak, AKN9108JCampbell Aircraft Restorations · London, KYN9108KHicks William A Jr · Mount Airy, NCN9108NMottinger Thomas A · Elizabeth, CON9108WCope James Brandon · Canyon, TXN9109HJunior Coal Contracting Inc · Philipsburg, PAN9109LYellowbird LLC · Lititz, PAN9109PPondo Inc · Wilmington, DEN9109QBurns Timothy M · Huntington, NYN9109WJenkins Jon Richard · Kaufman, TXN9109ZO'Neill Erik M · Williamsville, NYN910ANational Industrial Services LLC · Kingshill, VIN910CCG/A Enterprise LLC · Elizabeth, CON910CPCivil Air Patrol Inc · Maxwell Afb, ALN910DKUpside Down Holdings LLC · Sherman Oaks, CAN910GSRobinson Nicholas Anthony · Westborough, MAN910HPState Of Ohio · Columbus, OHN910LCEuroaviation Inc Trustee · KematenN910MABbmd LLC · Wichita, KSN910MMMitchell James F · Bakersfield, CAN910MREcho Dynamics · La Mesa, CAN910PCOverton James Nowlin · Jacksonville, FLN910PFCertified Aviation LLC · Morristown, NJN910PSSpitzer Helicopter LLC · Woodland Hills, CAN910SHF-1 Aviation LLC · Port Orange, FLN910TPMuhle Duayne K · Columbus, NEN910VLBlue Waters Air Chaters LLC · San Juan, PRN91105Marr Brandon J · Monmouth, ORN91106Vantreese Farms Inc · Monte Vista, CON9110HSierra Aero LLC · Truckee, CAN9110JRkd Aviation Services Inc · Dallas, TXN9110PBarron Gerald V · Carmel, CAN9110UPiper Aircraft Inc · Vero Beach, FLN9110WRg Air LLC · Muscle Shoals, ALN91117White Wings LLC · Anchorage, AKN9111DEmery Craig A · Wasilla, AKN9111GMaryland State Police · Baltimore, MDN9111KWdiaz Design Inc · Sunny Isles Beach, FLN91126Valiair Lc Trustee · Casper, WYN9112CCk Jet LLC · Hillsboro, MON9112JCmm Aviation LLC · Dover, FLN9112LRockey Bruce G · Bitely, MIN9112PRoesel Aviation LLC · Thomasville, GA
Back to AD 87-10-06 R1