Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N4335LClifford Gary G · Titusville, FLBuilt 1966 · S/N 17254404 N4336LWiff Robert A · Tahuya, WABuilt 1966 · S/N 17254406 N4337LWirt James · Goldsby, OKBuilt 1966 · S/N 17254408 N4337QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260237 N4338LInsco Kay · Martin, TNBuilt 1966 · S/N 17254409 N4338QRegistration Pending · Salisbury, NCRegistration pendingBuilt 1971 · S/N 17260238 N4339QC & K Aero LLC · La Valle, WIBuilt 1971 · S/N 17260239 N433LLSkydive Coolidge Inc · Tempe, AZBuilt 1963 · S/N 18254737 N433SBRico Kermot Aviation LLC · San Clemente, CABuilt 1969 · S/N 18259876 N4341LCut And Snip Flyers LLC · South Weber, UTBuilt 1966 · S/N 17254412 N4342LChenaille Lawrence A · Martinsville, INBuilt 1966 · S/N 17254413 N4343LDiamond C Aviation LLC · Gentry, ARBuilt 1966 · S/N 17254414 N4343QK M Air Enterprises Inc · Corona, CABuilt 1971 · S/N 17260243 N4344LTorbett William H Jr · Stockbridge, GABuilt 1966 · S/N 17254415 N4345QNeptune Aviation Services Inc DBA · Missoula, MTBuilt 1971 · S/N 17260245 N4346QCorrado Christian Blake · South Point, OHBuilt 1971 · S/N 17260246 N4347LChristiansen Steven P · Spokane, WAS/N 17254418 N43490Phillips Aviation LLC · Winnemucca, NVBuilt 1966 · S/N 17253653 N434CBYates David M · Haysi, VABuilt 1972 · S/N 15074214 N4351LWaggener James Franklin Jr · West Memphis, ARBuilt 1966 · S/N 17254424 N4351QJohnson James Benjamin · Rosharon, TXBuilt 1971 · S/N 17260251 N4353QHaley Paul M · Hillsboro, NHBuilt 1971 · S/N 17260253 N4355QSalcido Antonio Sr · Idaho Falls, IDS/N 17260255 N4358LMays John Anthony Sr · Cedar Hill, TXS/N 17254431 N4359LKoschara Nathaniel L · Geneseo, NYBuilt 1966 · S/N 17254433 N4359QDollar Christopher S · Spring Hill, TNBuilt 1971 · S/N 17260259 N4360QStoll Paul C · Blossom, TXBuilt 1971 · S/N 17260260 N4361LFairbault Sky Club Inc · Waseca, MNBuilt 1966 · S/N 17254436 N4362QQuacker Holdings LLC · Aspen, COBuilt 1971 · S/N 17260262 N4365LPriem Ben · Linwood, MIBuilt 1966 · S/N 17254440 N4365QJackson Rickey L · Edmond, OKBuilt 1971 · S/N 17260265 N436SAClark Vernon · Olalla, WABuilt 1967 · S/N 15067549 N4370LAir North Flying Club · Malone, NYBuilt 1966 · S/N 17254447 N4371LPrisk Jack J · Pride, LABuilt 1966 · S/N 17254448 N4373LWilliams Matthew W · Fort Walton Beach, FLBuilt 1966 · S/N 17254450 N4374QWillaero LLC · Union City, TNBuilt 1971 · S/N 17260274 N4376QFranke Russel G · Silt, COS/N 17260276 N4377QStacey James · Exeter, MEBuilt 1971 · S/N 17260277 N4378LRegistration Pending · Wentzville, MORegistration pendingBuilt 1966 · S/N 17254457 N4378QWings Flying Club Inc · South Bend, INBuilt 1971 · S/N 17260278 N4379QHagaman Edward T · Tolland, CTBuilt 1971 · S/N 17260279 N4381QAero Wise Services LLC · Decatur, TXBuilt 1971 · S/N 17260281 N4382LFielding Gregory J · Holland, MABuilt 1966 · S/N 17254461 N4382QLegends Air LLC · Wilmington, DES/N 17260282 N4383LHasman Robert B · Flushing, MIS/N 17254462 N4383QBladen Aviation Inc · Elizabethtown, NCBuilt 1971 · S/N 17260283 N4384QMorten John E · Larimore, NDBuilt 1971 · S/N 17260284 N4385QKulis Richard W · Gill, MABuilt 1971 · S/N 17260285 N43860Friends Of Army Aviation · Ozark, ALS/N R172-0124 N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287

Back to AD 72-03-03 R3