Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N5243XMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1969 · S/N 186 N5243ZJinkins Richard D · Rewey, WIS/N 22-8925 N52440Hap'S Air Inc · Ames, IABuilt 1981 · S/N 17274523 N52441Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274524 N5244EOpal Aviation LLC · Athens, GABuilt 1978 · S/N 17271794 N5244LGarman Daniel L · Burr Oak, KSBuilt 1968 · S/N 28-4539 N5244RClauson Ed P · Charlestown, RIBuilt 1974 · S/N 17263458 N5244VKnucklehead Aviation LLC · Cedar City, UTBuilt 1980 · S/N 172RG0481 N5244XFrantz William T · Wasilla, AKBuilt 1969 · S/N 184 N5245KPerun Av LLC · Cliffside Park, NJBuilt 1980 · S/N 17274029 N5245VMarianas Air Transfer Inc · Saipan, MPBuilt 1980 · S/N 172RG0482 N5245WSwartzfager Lee C · Corry, PABuilt 1962 · S/N 28-287 N52465Clutter Mark R · Spencer, OHS/N 177RG1195 N5246LSmithson Thomas E · Franklin, TNBuilt 1967 · S/N 28-4541 N5246MFlorida Aviation Career Training Inc · Saint Augustine, FLBuilt 1978 · S/N MC-564 N5246PYoyodyne Group Inc · Wilmington, DES/N 24-277 N5246QEast Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 15285092 N5246UMize Helicipter LLC · Edmond, OKS/N 172RG0298 N5246WScovil Jarin K · Laramie, WYS/N 28-288 N52473American Patrols Inc · Midland, TXBuilt 1980 · S/N 17274535 N52476Good Guys Flying Club LLC · Colorado Springs, COBuilt 1977 · S/N 177RG1197 N5247RHarbour Aviation LLC · Weatherford, TXBuilt 1974 · S/N 17263461 N5247TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225371 N5247XTexas Skies Flight School LLC · Boerne, TXBuilt 1969 · S/N 183 N5247ZBard Alexander T · Portland, ORS/N 22-8930 N52483Walsh Air Enterprises · Sugar Land, TXBuilt 1980 · S/N 17274537 N52489Cardinal Club Llp · Fargo, NDBuilt 1977 · S/N 177RG1198 N5248PKnox Edward R · Gulfport, MSBuilt 1958 · S/N 24-279 N5248TDopfel Sierra M · Udall, KSBuilt 1972 · S/N 28-7225372 N5248UStephens Robert Z · Missoula, MTBuilt 1980 · S/N 172RG0300 N5248WBalfa Joshua · Lumberton, TXBuilt 1962 · S/N 28-290 N5248ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8931 N52493Lasky Matthew T · Constable, NYBuilt 1977 · S/N 177RG1199 N52497Hobar Geoffrey · Hoffman Estates, ILBuilt 1977 · S/N 177RG1201 N5249DQuicksilver Skycraft LLC · Langley, WAS/N 17272470 N5249EAlexandria Aviation Inc · Alexandria, MNBuilt 1978 · S/N 17271797 N5249JWhitgo LLC · Lucas, TXBuilt 1980 · S/N 17273744 N5249RHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1974 · S/N 17263463 N5249TTri-Angle Aviation LLC · Henderson, KYBuilt 1972 · S/N 28R-7235204 N5249ZCreger Paul L Jr · Springport, MIBuilt 1961 · S/N 22-8933 N524AVGrant Aviation Inc · Anchorage, AKBuilt 2015 · S/N GA8-15-214 N524BHHoot Brian D · Toledo, OHBuilt 2008 · S/N 2280 N524BQHfaw LLC · Augusta, GABuilt 1999 · S/N 18280456 N524CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283031 N524CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843924 N524DKCrane Doug M · Ellisville, MOBuilt 2004 · S/N 4051 N524DRRegistered aircraftBuilt 1963 · S/N 18-7948 N524FLMoore Bruce W · Aledo, TXBuilt 1971 · S/N 28-7125351 N524GKbeh Hangar Flyers LLC · Bridgman, MIBuilt 2004 · S/N 26 N524GSSilver Gary S · Farmington, UTBuilt 1994 · S/N A001

Back to AD 81-18-04 R2