Skip to content

Registered aircraft · 1,267

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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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.

N1004PVankirk Malcolm R · Frederick, MDBuilt 1954 · S/N 23-6 N1008NK W Racing LLC · Angola, INBuilt 1973 · S/N 27-7305152 N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431 N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050 N1017PZeivogel Jeanine · Gulf Shores, ALBuilt 1954 · S/N 2319 N101HHElmhurst Holdings LLC · East Rochester, NYBuilt 1980 · S/N 27-8054057 N101NWVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1961 · S/N 27-475 N101PLHay William G Jr · Gualala, CAS/N 27-7754156 N101SLSweet Potato Flying Club LLC · Kalamazoo, MIBuilt 1959 · S/N 23-1832 N101UAReichard David Elijah · Breinigsville, PABuilt 1960 · S/N 23-1950 N1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35 N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302 N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135 N103RSZielke Michael M · Chuluota, FLBuilt 1957 · S/N 23-1165 N105CHMach Tuck LLC · Daytona Beach, FLBuilt 1974 · S/N 27-7405419 N105EBHardy Randall B · Argyle, TXBuilt 1956 · S/N 23-460 N1065PChisum Robert · Lorenzo, TXS/N 23-75 N106JLMusic City Air LLC · Rogersville, ALBuilt 1963 · S/N 27-2416 N1071PFlying Circus Aircraft LLC · Manitou Beach, MIBuilt 1954 · S/N 23-82 N107PAPacific Fleet Aviation LLC · Rochester, NYS/N 27-7854002 N10853St Johns Marine DBA · San Mateo, FLS/N 277854024 N1089PDetert Bradley · Valparaiso, INBuilt 1954 · S/N 23-98 N109CCTrans-Caribbean Air Exp & Imp Inc · Miami, FLBuilt 1968 · S/N 27-4024 N10YDDavenport Jimmy J · Hayesville, NCBuilt 1965 · S/N 27-2892 N1116PSale Reported · Scottsville, VASale reportedBuilt 1955 · S/N 23-126 N111DLCresence LLC · Port Saint Lucie, FLBuilt 1976 · S/N 27-7654167 N111MYMeshed Networx LLC · New Market, VABuilt 1978 · S/N 27-7854092 N1123PRegistration Pending · Flint Hill, VARegistration pendingS/N 23-133 N1131PDBA Congdons Aviation Service · Anchorage, AKS/N 23-141 N1132PR & S Stuart Co Inc · Wilmington, DEBuilt 1955 · S/N 23-142 N1134PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 23-146 N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226 N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152 N1158PLorenzo Walker Institute Of Tech · Naples, FLBuilt 1955 · S/N 23-171 N115JDC R Aviation Inc · Miami, FLS/N 27-7405395 N1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1955 · S/N 23-180 N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181 N116MFWeber Donald E · Saint David, AZS/N 27-3522 N1172PSteed William B · Winnsboro, SCS/N 23-175 N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188 N1189PParks Eric · Matthews, NCBuilt 1955 · S/N 23-203 N1197PPenley Steven A · Corinth, TXBuilt 1955 · S/N 23-212 N11MPAtwill Brock · Paragould, ARBuilt 1972 · S/N 27-4821 N11MTSpeedy Aviation LLC · Liberty, SCBuilt 1978 · S/N 27-7854064 N11PZCentral Virginia Flyers LLC · Palmyra, VABuilt 1971 · S/N 27-4699 N11TDDuflo Spray Chemical Inc · Lowville, NYBuilt 1960 · S/N 27-271 N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223 N120DUnited States Air Force Owner · Hanscom Afb, MABuilt 1972 · S/N 27-4799 N1210PRegistration Pending · Independence, MORegistration pendingBuilt 1955 · S/N 23-226 N1215PTucker Robert B · Melba, IDBuilt 1955 · S/N 23-234

Back to AD 88-21-07 R1