Skip to content

Registered aircraft · 6,238

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:87-18-06-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:87-18-06-R1') 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:87-18-06-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:87-18-06-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:87-18-06-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:87-18-06-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.

N234APOrr Lynn E · Fredericksburg, OHBuilt 1988 · S/N CE-1232 N234JEAimrich Enterprises · Wilmington, DEBuilt 1987 · S/N CE-1193 N234MGDubin Wayne M Trustee · Fort Myers, FLBuilt 1977 · S/N TE-1104 N234PTJaguar Management Group LLC · Wilmington, DEBuilt 2000 · S/N EA-662 N234SDHerndon Aviation LLC · Kokomo, INBuilt 1981 · S/N EA-200 N234WWMcadams James P · Valley View, TXBuilt 1979 · S/N CE-878 N23523Fox & Bear Air Charters LLC · South Padre Island, TXBuilt 1977 · S/N E-1175 N23524San Francisco Peaks Trucking Inc · Flagstaff, AZBuilt 1978 · S/N E-1174 N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865 N23534Schwabenton William J · Greensboro, NCBuilt 1977 · S/N CE-751 N23540State Of Iowa · Iowa City, IABuilt 1977 · S/N E-1180 N23541Registration Pending · Middleburg, FLRegistration pendingBuilt 1977 · S/N E-1182 N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085 N2354FBarbee William Terry · Weslaco, TXBuilt 1998 · S/N E-3154 N23551S&M Aviation (A Co Limited Liability Co) · Colorado Springs, COBuilt 1977 · S/N E-1183 N2355TBe-3195 LLC · Conway, ARBuilt 1998 · S/N E-3195 N23571Dlat Holdings LLC · Allen, TXBuilt 1977 · S/N TE-1120 N23578Green Law Aviation Inc · Culpeper, VABuilt 1977 · S/N E-1185 N2357NCreviston Steven Eric · Greensboro, NCBuilt 1998 · S/N E-3157 N23583Ingersoll David K · Trinity, ALBuilt 1978 · S/N D-10087 N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889 N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827 N2359LJ & M Baling Inc · Farmington, NMBuilt 1998 · S/N E-3159 N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134 N235DCCalley Darryl E · Snyder, TXS/N CE-750 N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443 N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446 N235SEPlane Flt LLC · Broken Arrow, OKBuilt 1981 · S/N E-1953 N235SGZonaair LLC · Roll, AZS/N E-3544 N235SMTriniair LLC · Warner Robins, GAS/N TH-926 N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088 N23608Beech36 LLC · Clarkston, MIBuilt 1978 · S/N E-1188 N23609Wiebelhaus John J · Strasburg, COBuilt 1978 · S/N D-10089 N23612Lcms Limited · Durham, NCBuilt 1977 · S/N CE-756 N23615Yoder Metal & Post Frame & Building Supplies · Haven, KSBuilt 1977 · S/N E-1191 N23620Erickson Brian C · Pahrump, NVBuilt 1977 · S/N E-1165 N23621Excellance Inc · Madison, ALBuilt 1977 · S/N E-1192 N23639Teleprint Inc · Rydal, PABuilt 1978 · S/N E-1293 N23642Samson Motors Inc · Redmond, ORBuilt 1977 · S/N CE-759 N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146 N23682Next Century Aviation Oregon LLC · Sausalito, CABuilt 1978 · S/N E-1205 N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099 N236BEMcgill Benjamin D · Larchmont, NYBuilt 1981 · S/N E-1825 N236CHGta Air Inc · Addison, TXBuilt 1973 · S/N E-502 N236HPProctor John M · Spotsylvania, VABuilt 1987 · S/N E2399 N236JPLauderdale Thomas J · Bates City, MOBuilt 1970 · S/N E-211 N236MMFunkhouser Robert Scott · The Woodlands, TXBuilt 2003 · S/N E-3514 N236RMConrad Harold M · Sugar Grove, ILBuilt 1979 · S/N EA-43 N236SRb Aviation Enterprise LLC · Palm City, FLBuilt 2004 · S/N E3555 N236TCCka Investments LLC · Fernandina Beach, FLBuilt 1979 · S/N EA-23

Back to AD 87-18-06 R1