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.
N9610BGoodman Aviation LLC · Choteau, MTN9610CHageman Theron · Jay Em, WYN9610DHicks Joseph O · Germanton, NCN9610QUS Aviation Group LLC · Denton, TXN9610RReynolds Kirk S · Skaneateles, NYN9610UMaschek Anthony Q · Harker Heights, TXN9611CSamrat Prithviraj Inc · Miami, FLN9611JStull Donald K · Catawba, NCN9611MElectron Neutrino Inc · Lewes, DEN9611UKingsley Paul A II · Idledale, CON9612DSoto Edward · Wasilla, AKN9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingN9612JReich Gregory N · Schwenksville, PAN9612UElizabeth B Hawley · Wichita Falls, TXN9612VLe Roux Rocco · Carlsbad, CAN9612WJama Aviation LLC · Blaine, MNN9613HFiedler Mark · Wichita, KSN9613JKraun Fred M · Fall City, WAN9613MLeland Erik J · Beaverton, ORN9613UGlenn Thomas Joel Hr · Fort White, FLN9613WAir Wilma LLC · Tijeras, NMN9614Grohsmeyer Steven P · Franklin, KYN9614CBravo Foxtrot Zulu Holdings LLC · Unionville, CTN9614EWeber William J · Durham, NCN9614HC&H Elite Air LLC · Johnstown, CON9614JSkinner Roger · Delanson, NYN9614MSmith Michael O · Conroe, TXN9614QConrad Terry E · Lancaster, OHN9614SFlatonia Veterinary Clinic Inc · Flatonia, TXN9614WByrne Matthew A · West Allis, WIN9615CD Wayne Hollar Jr Dds Pa · Lenoir, NCN9615DPeterson Thomas M · Park Rapids, MNN9615MMorgan Mark · Durango, CON9615RAlbright Frank · Elba, ALN9615UKnutson Duane G · Brookings, SDN9615ZTampa Bay Soaring Society Inc · Zephyrhills, FLN9616ABoyd Ronald J · Genoa, CON9616JGarsteck Paula · Put In Bay, OHN9616LMid Island Air Service Inc · Ronkonkoma, NYN9616MBohn Aaron L · Valdosta, GAN9616QClearview Flying Club Inc · Westminster, MDN9616RPray Aviation Inc · Augusta, KSN9616WKohut Jeanette G · Southern Pines, NCN96177B2 Cpr Plus Inc · Bermuda Dunes, CAN9617CPete And Pete Sales Inc · Williamsville, NYN9617DWinton Christopher M · Valley Center, KSN9617HShinn Lake D · Stevensville, MTN9617JBeaverdam Aeronautics LLC · Chatom, ALN9617MSlusser Dennis G · Biggs, CAFirst renewal noticeN9617QKagin Corp · Wilmington, DE
Back to AD 87-10-06 R1