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.
N79445Raniolo James · Jackson, WYN79447Aroostook Aviation LLC · Millinocket, MEN79448Thomas William B · Converse, LAN7944CAugter Gary K · Mcalester, OKN7944GBogardus Peter S · Gouverneur, NYN7944HForsgren Kyle C · Wasilla, AKN7944NInspire Aviation LLC · Magnolia, TXN7944POber John A · Candor, NYN7944WPadisak Michael · Traverse City, MIN79450Smith Jeff C · Cincinnati, OHN79453Zimmer James E · Corning, CAN79454Gavranovic Willie · Wharton, TXN7945GWinger Matthew · Vail, AZN7945LBertsch David L · Caldwell, IDN7945NWittenbrader Jeffrey M · Lake Ariel, PAN7945PArey Paul R · Cambridge, MDN7945WOnward Enterprises LLC · Laurel, MSN7945YLevel Up Aviation LLC · Newton, ALN79468Whitmire Alan K · Canyon Lake, TXN7946GRegistration Pending · Beach City, TXRegistration pendingN7946NSommer Matthew D · Whiteford, MDN7946PLarsen Jordan T · Draper, UTN7946WCushman Jeffrey R · Superior, WIN79472Frey Michael L III · Waco, TXN79475Registered aircraftN79477Shipley David L · Yates City, ILN79478Fusano Lisa A · La Crescenta, CAN79479Larue Mark C · Leander, TXN7947GStearman Field Aircraft Repair LLC · Benton, KSN7947PThorpe Jack · Raleigh, NCN79482Matacotta Ernest A · Marietta, GAN79488Nevels Steven D · Merritt Island, FLN79489Maisonet Gonzalez Hector W · Ocala, FLN7948NHayes William B · Saint Charles, MON7948PDeruelle David · Shingle Springs, CAN7948WCruse Billy · North Bend, WAFirst renewal noticeN7949Thermoking Of Fargo & Isuzu Diesel Midwest · Fargo, NDN79493Bounds Trucking LLC · Faison, NCN79498Gord James F · Sandwich, ILN79499Johnson Benjamin M · Monroe, WIN7949NGuess-Slatosky Carrie · Randleman, NCN7949PWalters Donald J · Mohave Valley, AZN7949YReeve Howard E · Minot, NDN794AMeridian Aircraft LLC · Wilmington, DEN794AKFlying Dutchman LLC · Wasilla, AKN794BKMaxlines LLC · Fairfax, CAN794RSRegistered aircraftN794SATmb Aviation LLC · Fresno, CAN79501Skyhawk Flying Club Inc · Omaha, NEN79506Allen Michelle E · Sebastopol, CA
Back to AD 87-10-06 R1