AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5432HArmstrong Aviation Services LLC · Freeport, PAN5432JSouthampton Wing LLC · Southampton, NYN5432LPlanesworld LLC · Jasper, GAN5432MWorthington Loren D · Caldwell, IDN5432UEberling Bill · Central Point, ORN5432VMj Aerial LLC · Wasilla, AKN5432WVantilborg Craig S · Minot, NDN5433BBlue Moon Aviation LLC · Grangeville, IDN5433DWatkins Lawrence A · San Jose, CAN5433EAty Aviation Inc · Watertown, SDN5433LGray Sarah M · Boulder Creek, CAN5433PStephens Matthew T · Ocean Springs, MSN5433UHynes Kevin P · Wichita Falls, TXN5433XMk Air LLC · Lewistown, MTN54346Aviation Trust Company LLC Trustee · Oklahoma City, OKN5434ASteele Group Insurance Agency Inc · Eugene, ORN5434DSierra Lima Aviation LLC · Riverton, UTN5434EMiller Shane D · Cherokee, OKN5434PDavison Matt E · Pueblo, CON5434UVance Daniel · Bend, ORN54355Elizabeth City State University · Elizabeth City, NCN54357Rick Aviation Inc · Newport News, VAN5435AAmerican Airpower Heritage Flying Museum · Dallas, TXN5435BMacomber Gregory S · Kalamazoo, MIN5435DGoheen Robert Grant · Saint Petersburg, FLN5435EWings Over Texas Holdings LLC · Denton, TXN5435HWindham Brealon A · Kingsville, TXN5435WGabriel Juan J · Melbourne Beach, FLN54360A S Flight Academy LLC · Lantana, FLN54364Parker Realty Co · Brunswick, GAN54369Don Warren D · Chandler, AZN5436AJls Investments Inc · Lafayette, LAN5436DSeitz Aviation LLC · Hayden, IDN5436EKitsap Aviation Squadron Inc · Southworth, WAN5436FTowle Willard M · Lompoc, CAN5436HTrue Course Air LLC · Rich Hill, MON5436UNewsom William Joel III · Roswell, GAN54371Clare Air Services LLC · Saint Johns, MIN5437FLegacy Aviation LLC · Tea, SDN5437HBuena Vista Flying Club Inc · Richland Center, WIN5437JMiloud Chadd K · Fort Worth, TXN5437KStahlheber Billy P · College Place, WAN5437LRegistration Pending · Toquerville, UTRegistration pendingN5437PDeplorable Air LLC · Lakeland, FLN5437RSchafer Brian L · Carleton, MIN5437UBatdorf Richard E · Naples, FLN5437WRoutson David P · Dundee, MIN5437YHayman Russell P · Ocean City, MDN54381Paradise South Ventures LLC · Marco Island, FLN54384Above All Aviation Inc · Goleta, CA
Back to AD 2007-04-19 R1