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.
N7798WLeopard James · Huntersville, NCN7799DParkerson Stan L · Fairbanks, AKN7799VCb Aerial Application LLC · Kirksville, MON7799ZMid Atlantic Soaring Association · Frederick, MDN779AKJust Plane Partners LLC · Yorba Linda, CAN779DSSaucier Dana A Jr · Dublin, OHN779DZPollux Aviation Ltd · Wasilla, AKFirst renewal noticeN779GCareer Pilot Training LLC · Wilmington, DEN779GS779 Aviation LLC · Dover, DEN779JNTorque Aviation Inc · Smithfield, VAN779KSIsland Air Charters Inc · Ft Lauderdale, FLN779KTTurner Keith R · Coupeville, WAN779LKAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CAN779MRRock N Robins Flying Service LLC · Palm City, FLN779PTMacon Air LLC · Franklin, NCN779RVBusby Jorge B · Monroeville, ALN779SHHillsboro Aero Academy LLC · Hillsboro, ORN779WMGoldman Jon L · Smithtown, NYN779XCJensen Michael C · Bainbridge Island, WAN779ZGiarratana Stephen J · Clinton, MSN77AJGreen Nicholas S · Lakeland, TNN77AKRivers Paul E · Shannon, ILN77AXWest Jeffrey N · Holladay, UTN77BLLesnett Robert Gage Trustee · Vida, ORN77BWWhitaker Eric · Detroit, TXN77CHTcb Management Inc · Chiefland, FLN77CTHays Cory W · Beaumont, TXN77CVNaikelis Robert · Hampstead, NCN77DDFenger Thomas A · Palmer, AKN77DHBramon Bruce M · Sunrise Beach, MON77DRGeodetic Associates International LLC · Pittstown, NJN77DSBalderas Alberto · Harlingen, TXN77DUChaffee Merilyn D · Angwin, CAN77DXWolfert Jonathan M · Dallas, TXN77EBBowles Alan B · Georgetown, TXN77EKRv 7 77 LLC · Port Saint Lucie, FLN77ERFrech Betty J Trustee · Columbia, MON77EWBellanca Aviation Of Blairstown LLC · Andover, NJN77FLMeyer Adnrew J · Clear Lake, IAN77FPRegistration Pending · New Richmond, WIRegistration pendingN77FSRoberts Eric · Grayslake, ILN77GATaliaferro John C · Abilene, TXN77GBSmith Kevin F · Sherman, TXN77GDN77gd LLC · Kalispell, MTN77GGCoben Craig S · Smithville, OHN77GHWagner Rickey J · Stacy, MNN77GLLange Cory J · Blaine, MNN77GMMartin Gustavo E · Cooper City, FLN77GRHubbard Benjamin L · Quogue, NYN77HXAppold Dave J · Bay City, MI
Back to AD 87-10-06 R1