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.

N48924Cobb Susie O · Fayetteville, TNBuilt 1977 · S/N 15281051 N4892TTwo Tango Aviation LLC · Plant City, FLBuilt 1972 · S/N 28R-7235132 N48932Poursartip Nader · Hayward, CABuilt 1977 · S/N 15281056 N48935Chambers Wyatt Allan · Ludlow, MABuilt 1977 · S/N 15281059 N48938International Flying Club Inc · Winfield, ILBuilt 1977 · S/N 15281060 N4893ELjl & D Inc · Wilmington, DEBuilt 1978 · S/N 17271673 N4893GBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17273440 N4893JMartineau Aircraft Inc · Butte, MTBuilt 1979 · S/N 17273692 N4893PTri-City Helicopter Services Inc · Richland, WABuilt 1961 · S/N 27-477 N48941Somboonsap Patanapong · Fort Lauderdale, FLBuilt 1977 · S/N 15281062 N4894AHagenston Arthur J · Fairbanks, AKBuilt 1956 · S/N 18-4996 N4894EPlyler Aviation Lp · Sherman, TXBuilt 1959 · S/N 7GC-68 N4894LPeairs Gregory Ross · Sacramento, CABuilt 1967 · S/N 28-4261 N4894TBar Aviation LLC · Madison, ALBuilt 1981 · S/N R18201782 N4895AHigh Exposure Inc · Wilmington, DEBuilt 1956 · S/N 18-4997 N4895GWilson Forest B · Hollister, CABuilt 1979 · S/N 17273442 N4895PKlein Barry A · Friday Harbor, WABuilt 1961 · S/N 27-482 N4895SFoster Bryan A · Malabar, FLBuilt 1971 · S/N 32-7100024 N4895VEbrite Richard P · Long Beach, MSBuilt 1980 · S/N 172RG0410 N48961Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281074 N48966Kapellair LLC · Wickenburg, AZBuilt 1943 · S/N 230 N48967N48967 LLC · Mount Pleasant, SCBuilt 1977 · S/N 15281079 N4896GGecha Richard Mike · Florence, VTBuilt 1979 · S/N 17273443 N4896LMike Delta Kilo LLC · Bentonville, ARBuilt 1967 · S/N 28-4263 N4896MSmtm Holdings Inc · Wilmington, DEBuilt 1981 · S/N 17274294 N4896TVosler Dean S · Bay City, MIBuilt 1972 · S/N 28-7225233 N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411 N48972Pickett Matthew A DBA · Gig Harbor, WABuilt 1978 · S/N 15281083 N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674 N4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeBuilt 1976 · S/N 28-7790071 N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444 N4897YKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4704 N4898BPrecon Inc · Anaheim, CABuilt 1979 · S/N 15283697 N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097 N4898WSorce Angelo J · Dandridge, TNBuilt 1977 · S/N 14228 N4898YSimmons Mark Adba · Pawcatuck, CTBuilt 1968 · S/N 25-4705 N48990Hyldburg Aviation · Plymouth, MABuilt 1977 · S/N 15281090 N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446 N4899LSweat Larry D · Meridian, IDBuilt 1967 · S/N 28-4266 N4899PC E S Corporation · Charleston, WVRevoked, canceledBuilt 1961 · S/N 27-487 N489ACKuza Flyers LLC · Rock Hill, SCBuilt 1999 · S/N 413-98 N489ALHehl Adam D · Anchorage, AKBuilt 1956 · S/N 18-4769 N489BBBoatman John H Jr · Smyrna, TNS/N JB001 N489BCAviation Services Inc · Barre, VTBuilt 1974 · S/N 17264443 N489BJNo Air Services LLC · Holbrook, NYBuilt 1989 · S/N 2811028 N489CYW Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1973 · S/N 28-7310121 N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083 N489JOrr Matthew W · Kirkland, WAS/N 265 N489JEChambless Mardre F II · Panama City, FLBuilt 2004 · S/N 90508 N489LARed Baron LLC · Middletown, DES/N 47007T

Back to AD 81-18-04 R2