Registered aircraft · 177

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:79-01-02-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:79-01-02-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:79-01-02-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:79-01-02-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:79-01-02-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:79-01-02-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.

N5080HBemidji Aviation Services Inc · Bemidji, MNBuilt 1961 · S/N LF-27 N5080LBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-59 N50HTDunteman William M · Big Rock, ILBuilt 1960 · S/N HH-131 N51685Midland Avionics LLC · Louisville, KYS/N LC-40 N527QSilver Linings Air And Farm LLC · Chamblee, GABuilt 1968 · S/N LC-284 N536DShiloh Aviation LLC · Ramer, TNBuilt 1962 · S/N DH-338 N5452WTechnical Education Services Inc · Virginia Beach, VABuilt 1965 · S/N LC-191 N55SABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-243 N58KSMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1958 · S/N DH-165 N5FPittsburgh Institute Of Aeronautics · Pittsburgh, PABuilt 1957 · S/N DH-131 N5GYSeven Sierra Yankee LLC DBA · Monroeville, PABuilt 1924 · S/N JH-171 N602PPayne Mark Robert Jr · Germantown, TNBuilt 1959 · S/N DH-224 N60FXAmeriflight Management Services Inc · Orlando, FLBuilt 1968 · S/N LC-312 N60NKKirchhoefer John D · Orlando, FLBuilt 1969 · S/N LC-328 N611DRK & A Solutions LLC · Summerfield, NCS/N DH-274 N61TBJay Travis · Vero Beach, FLBuilt 1961 · S/N JH-156 N627BMGist Brett · Poolville, TXBuilt 1962 · S/N DH-322 N628ZGlantz Richard L · Whitefish, MTBuilt 1956 · S/N DH-123 N632ZReady Aim Flyer LLC · New Castle, DES/N DH-113 N648DCSomerset Regional Water Resources · Friedens, PAS/N LD-351 N6558Metropolitan Airport Authority · Moline, ILS/N 85 N659Gulf South America Air Transport Inc · Mobile, ALS/N LC72 N65CSChallans Robert F · Hesston, KSS/N LC-82 N65QAGulf States Air Inc · Bossier City, LAS/N LC-165 N66GMEdge Logistics Inc · Southlake, TXBuilt 1969 · S/N LB-1 N66QMSammons Shaun W · Memphis, TNBuilt 1957 · S/N DH-161 N6890QSoest Dean · Quartz Hill, CABuilt 1965 · S/N LD-224 N697TMilguard Aviation Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1960 · S/N DH-252 N6AQNyerges James · Midland, TXBuilt 1964 · S/N LD-214 N7034ERange View Investments LLC · Austin, TXBuilt 1962 · S/N LF-49 N7055MPaul John · Hamilton, MTS/N LH174 N721BStandel David · Jacksonville, FLBuilt 1956 · S/N DH-115 N738WBNord Aviation Inc · Pembina, NDBuilt 1960 · S/N DH-286 N747VWHammer Aviation LLC · Miami, FLBuilt 1967 · S/N LD-360 N7502NBemidji Aviation Services Inc · Bemidji, MNS/N LD-391 N76LThacker Flying Club LLC · Griffin, GAS/N DH-183 N76RTEmax LLC · Perry, GABuilt 1970 · S/N LB-27 N773AGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1960 · S/N HH-130 N7770XT Bone Air LLC · Missoula, MTBuilt 1960 · S/N HH-139 N7817LNyerges James · Midland, TXBuilt 1967 · S/N LD-340 N787SCSilverthorne Adam · Walnut Creek, CABuilt 1962 · S/N DH-324 N7PCMoorhead Equipment LLC · Belton, SCBuilt 1966 · S/N LC-246 N800EQMccauley Kerry D · Menomonie, WIBuilt 1960 · S/N LF-24 N800QACitadelle Holdings LLC · Palmetto Bay, FLBuilt 1962 · S/N LD-29 N80RRBemidji Aviation Services Inc · Bemidji, MNBuilt 1966 · S/N LD-296 N80TBGraphite Consulting Inc · Woodland, CABuilt 1963 · S/N DH-344 N8108REdge Logistics Inc · Southlake, TXBuilt 1969 · S/N LC-329 N810ADGulf States Air Inc · Bossier City, LAS/N LD-328 N811ACUnited States Construction Corp · Pompano Beach, FLBuilt 1959 · S/N DH-239 N814JEEasca LLC · Little Rock, ARBuilt 1956 · S/N DH-106

Back to AD 79-01-02 R2