Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N300JTMentor Capital LLC · San Antonio, TXBuilt 1978 · S/N 34-7970074 N300KRWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1976 · S/N 28R-7635210 N300MMHamblin Kenneth · Stanton, TNBuilt 1965 · S/N 30-851 N300PAAero Maintenance Inc · Vancouver, WABuilt 1974 · S/N 28R-7435206 N300REMoreau Leo B · Wasilla, AKBuilt 1965 · S/N 30-841 N300RJTcj Kqc LLC · Robstown, TXBuilt 1976 · S/N 32R-7680286 N300VMDavis Laramie · Canyon, TXBuilt 1976 · S/N 32R-7780120 N300WLRosen Robert D · Lewisville, NCBuilt 1977 · S/N 32R-7780474 N30100Jetstream Cowboys LLC · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870463 N301ABCamber Aviator LLC · Miami, FLBuilt 1979 · S/N 34-7970186 N301EEPacker William M III · Bloomfield Twp, MIS/N 32R-7780469 N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916 N3020KGhostwriter Airshows LLC · Hustonville, KYBuilt 1978 · S/N 34-7970099 N3028NPryor Paul Robert · Carrollton, VABuilt 1979 · S/N 34-7970116 N302EFRedbird Ventures LLC · Kalispell, MTS/N 34-7350328 N3030MIn Line Aviation LLC · Greensburg, PABuilt 1977 · S/N 28R-7837109 N3030WZadnik Gary R · Vacaville, CAS/N 24-3534 N30325N30325 LLC · Lakeland, FLBuilt 1978 · S/N 28R-7837313 N3033MPhil-Flyers Club Inc · Amarillo, TXBuilt 1977 · S/N 28R-7803160 N3036JSebring Aviation Of Highlands County Inc · Sebring, FLBuilt 1976 · S/N 32R-7680097 N303MMBrown Properties Of Ga Inc · Silver Creek, GABuilt 1977 · S/N 34-7870027 N303PPDuke Raymond E · Columbia Station, OHBuilt 1975 · S/N 28R-7535129 N303RCYogini Modi · Homestead, FLBuilt 1971 · S/N 34-7250016 N3048YAeronautica LLC · West Hollywood, CAS/N 34-7970196 N3049RRls Rental Co DBA · Joplin, MOBuilt 1969 · S/N 28R-35603 N3051XWagner Richard L · Conroe, TXBuilt 1979 · S/N 34-7970190 N3054KFerguson David G · Woodbridge, VABuilt 1979 · S/N 34-7970102 N3057RZavadil Clinton J · Sidney, IABuilt 1970 · S/N 28R-35618 N3057VBig H Transportation LLC · Traverse City, MIBuilt 1979 · S/N 34-7970168 N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620 N305VPGaskins Patrick A · Fort Lauderdale, FLS/N 32R-7780321 N3060RArrow N3060r LLC · Sheridan, WYBuilt 1969 · S/N 28R-35621 N30619Wrpl LLC · Mountain Brk, ALBuilt 1978 · S/N 34-7870467 N3061RCohns Willie · Elizabethtown, KYBuilt 1969 · S/N 28R-35622 N3063RGrant Scott A · Santa Barbara, CABuilt 1969 · S/N 28R-35624 N30640Christianson Cleet M · Enumclaw, WABuilt 1978 · S/N 28R-7803369 N3065RFlavin Patrick J · Woodbridge, VABuilt 1969 · S/N 28R-35626 N3066RParker Michael A · Milwaukee, WIBuilt 1969 · S/N 28R-35628 N3067QKpw Enterprises Inc · Chula Vista, CABuilt 1977 · S/N 32R-7780279 N3067RSmith Julia L · Big Bear City, CABuilt 1969 · S/N 28R-35627 N3068RIsland Aero LLC · Kailua, HIBuilt 1969 · S/N 28R-35629 N3069RBean Sheila L · San Antonio, TXBuilt 1969 · S/N 28R-35630 N306AKRobinson Thomas F II · Port Charlotte, FLBuilt 1966 · S/N 30-1253 N3072RRegistered aircraftBuilt 1969 · S/N 28R-35634 N3073MRobinson Robert F G · Round Rock, TXBuilt 1977 · S/N 28R-7803164 N3073RIngraham John W Jr · Redlands, CABuilt 1969 · S/N 28R-35633 N30746Tribe Of Judah Motorcycle Ministries Inc · Humble, TXBuilt 1978 · S/N 34-7870231 N3074RSchwietz Thomas E · Strasburg, VAS/N 28R-35635 N3078RKitaguchi Terry S · Stockton, CABuilt 1969 · S/N 28R-35638 N3079RGrace Ryan Aviation LLC · Tomball, TXBuilt 1969 · S/N 28R-35639

Back to AD 97-01-01 R1