Skip to content

Registered aircraft · 930

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

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:76-14-07-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2') ORDER BY n_number

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:76-14-07-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2')
  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:76-14-07-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2')
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.

N3712YRpx Technologies Inc · Stillwater, OKBuilt 1963 · S/N 21058212 N3714YReichelt Mark C · Big Sandy, MTBuilt 1963 · S/N 21058214 N3717YOwosso Navigators Club LLC · Owosso, MIBuilt 1963 · S/N 21058217 N3719YG & G Famrs Of Gilbert Inc · Gilbert, LAS/N 21058219 N3728YPrt Aviation Corp · Wilmington, DEBuilt 1963 · S/N 21058228 N3731YHaglin Dana · Erie, COBuilt 1963 · S/N 21058231 N3733YHolliday Ivan Scott · Poplarville, MSBuilt 1963 · S/N 21058233 N3738YAirborne Solutions Group LLC · Dayton, OHBuilt 1963 · S/N 21058238 N3739YCessna 210 LLC · Ogden, UTBuilt 1963 · S/N 21058239 N3740YOmg Air LLC · Okeechobee, FLBuilt 1964 · S/N 21058240 N3743YCooper Jess D · Spanaway, WAS/N 21058243 N3746YWeed James A · Suwanee, GABuilt 1963 · S/N 21058246 N3747YCenturion Aviation Nevada LLC · Sparks, NVBuilt 1963 · S/N 21058247 N3748HVoth Michael K · Lynchburg, VABuilt 1963 · S/N 21058248 N3749YWestwind Homes Inc · Twin Falls, IDBuilt 1963 · S/N 21058249 N3750YMurphy Mark · Belleair, FLBuilt 1963 · S/N 21058250 N3753YWolfe Christopher D · Gilbert, AZBuilt 1963 · S/N 21058253 N3754YSullivan Eugene M · Cotter, ARBuilt 1963 · S/N 21058254 N3755YCecil Enterprises LLC · Gig Harbor, WABuilt 1963 · S/N 21058255 N3756XStephens Tanner B · Palmer, AKBuilt 1968 · S/N 21059075 N3759YManagement Support Services LLC · Naturita, COBuilt 1963 · S/N 21058259 N375HWWallace Charles · Fayetteville, ARBuilt 1963 · S/N 21058251 N375MKIntegrity S&J Properties LLC · Amarillo, TXBuilt 1963 · S/N 21058252 N3760YHarris Stephen T · Williamstown, KYBuilt 1963 · S/N 21058260 N3765YBott David F · Yukon, OKBuilt 1963 · S/N 21058265 N3766YPyanov Mark · Clinton, MSS/N 21058266 N3770YBig Bend C C Foundation · Moses Lake, WABuilt 1963 · S/N 21058270 N3772YKossuth Keith E · Sleepy Hollow, CAS/N 21058272 N3774YLanning 2 Aviation LLC · Amarillo, TXBuilt 1963 · S/N 21058274 N3778YTime Air LLC · Mendon, UTBuilt 1965 · S/N T210-0034 N3779YJoiner Matthew A · Temple, GABuilt 1963 · S/N 21058279 N3783YThompson Arthur H Jr · Hereford, AZBuilt 1963 · S/N 21058283 N3784YQualitair LLC · MichelstadtS/N 21058284 N3785YNational Snake Team LLC · Benton, LABuilt 1964 · S/N 21058285 N3786YWilliams John D · Geneva, OHBuilt 1963 · S/N 21058286 N3791YSatanta Flying Service Inc · Satanta, KSBuilt 1964 · S/N 21058291 N3793YBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1964 · S/N 21058293 N3797YCockroft Roger · Baltimore, MDBuilt 1964 · S/N 21058297 N3804YChelmo Jed E · Kimball, SDBuilt 1964 · S/N 21058304 N3805YMacys Flying Service Inc · Tulelake, CABuilt 1964 · S/N 21058305 N3806YOnion Crest Air LLC · Arcadia, NEBuilt 1964 · S/N 21058306 N3813YSheppard David A · Jackson, CABuilt 1964 · S/N 21058313 N3814YLadner Donald E · Centerville, TXS/N 21058314 N3815YBorean Anthony J · Olathe, COBuilt 1964 · S/N 21058315 N3819YLaycock Justin D · Johnson City, TNBuilt 1964 · S/N 21058319 N3824YMclaren Richard T · Sturbridge, MABuilt 1964 · S/N 21058324 N3825YAtlas Mining & Mechancial Inc · Beryl, UTBuilt 1964 · S/N 21058325 N3827YPrentice Ronald L · Winchester, CABuilt 1964 · S/N 21058327 N3828YHall Edmond · Bremerton, WABuilt 1964 · S/N 21058328 N3830YRice Kevin L · Pleasant View, COBuilt 1964 · S/N 21058330

Back to AD 76-14-07 R2