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.
N73190Flying J Enterprises LLC · San Antonio, TXN73192Nationwide Aviation LLC · Hudson Oaks, TXN73195Saratoga Flyers Inc · South Glens Falls, NYN73197Seward Kent · Parma, IDN73198Davis Jimmy R Jr · Wharton, TXN73199Performance Polymer Technologies LLC · Roscommon, MIN7319DN7319d LLC · Port Saint Lucie, FLN7319FJdnichols LLC · Wichita, KSN7319GPiguzov Yevgeniy · Hillsborough, NJN7319JGross Randolph A · Round Rock, TXN7319TAlberta Aviation LLC · Wyoming, MIN7319WDavis Jeffrey M · Phoenix, AZN7319XHays Software Development LLC · Timnath, CON731ACAtp Aircraft 9 LLC · Wilmington, DEN731CKRobinson Michael F · Granbury, TXN731JDReifschneider Harry III · Mesa, AZN731NDAir Shares LLC · Casper, WYN731PKC & M Properties LLC · Chesterton, INN731RHBallenger Kenneth L · Tucson, AZN731RTWarndahl John · Kyle, TXN731SBSchuler Edward A Jr · Hamden, CTN731SMSkyline Flight Services LLC · Millen, GAN731TATomlinson Aviation Inc · Ormond Beach, FLN731UACherry Hill Aviation Inc · Freetown, INN731WN64gs LLC · Van Nuys, CAN73200Burns Kurtis L · Clyde Park, MTN73209Goldberg Peter S · Eagle River, AKN7320FRick Aviation Inc · Newport News, VAN7320JNextgen Flight Academy Inc · Riverside, CAN7320WSuchting Carl Joseph · Little Egg Harbor, NJN7320YSpruce John P · Liberty Hill, TXN73213Haig Gene · Palatine, ILN7321FWebster Joshua P · West Rutland, VTN7321MWood Robert B · Woods Cross, UTN7321PTappan East LLC · New Philadelphia, OHN7322DRainey William F III · Mt Pleasant, TNN7322FEdixon James Richard II · Cameron Park, CAN7322PRuple Michael D · Palm Bay, FLN7322WLocum Mike M · Sparta, TNN7323DWilkerson Dwight T · Kirkland, WAN7323GSpiker Jeffrey A · Granville, OHN7323PCrawford Patricia C · Denton, NCN7323WHigh Desert Skys LLC · Blackfoot, IDN7323YFoster Jay W · Marshfield, MON7324DRuach LLC · Wilmington, DEN7324PWright Havis L · Pleasant Hill, MON7324WFerreira Barney Manuel · Truckee, CAN7324YMccaslin Dale Alan Trustee · Holt, MON73250Skaya Aircraft LLC · Buford, GAN73254Swensen Jason D · Norfolk, NE
Back to AD 87-10-06 R1