Skip to content

Registered aircraft · 40,396

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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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.

N734UPLee Randall Ross · Houston, TXS/N 17269127 N734UQFuture Technologies Inc · Colonia, NJBuilt 1977 · S/N 17269128 N734URKastle Todd Trustee · Gilroy, CAS/N 17269129 N734USLowery Dwight W · Clayton, NCBuilt 1977 · S/N 17269130 N734UTBlue Sky Aviation LLC · Menominee, MIBuilt 1977 · S/N 17269131 N734UUPenn Aero LLC · Lewisburg, PABuilt 1977 · S/N 17269132 N734UVCavu Flying Club · Wauwatosa, WIBuilt 1977 · S/N 17269133 N734UWFisher Stephen C Trustee · Lamar, ARS/N 17269134 N734UXJantz Carl R · Columbia, MOBuilt 1977 · S/N 17269135 N734UYAg & Csv Inc · Pine Bush, NYBuilt 1977 · S/N 17269136 N734UZDream Unthreatened LLC · San Luis Obispo, CABuilt 1977 · S/N 17269137 N734VCNashville Skyscrapers LLC · Old Hickory, TNBuilt 1977 · S/N 17269140 N734VEFlyby Aviation LLC · Logan, UTBuilt 1977 · S/N 17269142 N734VNKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1977 · S/N 17269150 N734VPBooth Danielle M · Somis, CABuilt 1977 · S/N 17269151 N734VQJprg Aviation Inc · Orlando, FLBuilt 1977 · S/N 17269152 N734VTDestination Aviation LLC · Destin, FLBuilt 1977 · S/N 17269155 N734VVSummit Flight Services LLC · Paden, OKBuilt 1977 · S/N 17269157 N734VXRed Door Aviation LLC · Dover, DEBuilt 1977 · S/N 17269159 N734VZTri Air Inc · Aulander, NCBuilt 1977 · S/N 17269161 N734WBWedoaero LLC · Vale, NCS/N 17269163 N734WFLewis Patrick K · El Dorado, ARS/N 17269167 N734WKWagner James M · Hockessin, DEBuilt 1977 · S/N 17269171 N734WNBoerne Flight Options LLC · Boerne, TXBuilt 1977 · S/N 17269174 N734WPLaps LLC · Elkhorn, WIBuilt 1977 · S/N 17269175 N734WRSealy Michael Robert · Summerville, SCBuilt 1977 · S/N 17269177 N734WSWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269178 N734WZTingman Christopher · Seattle, WABuilt 1977 · S/N 17269185 N734XMahler Steven · Hanover, PABuilt 1974 · S/N 28-7405079 N734XCCurrier William R · Ormond Beach, FLBuilt 1977 · S/N 17269188 N734XDByrne David · Three Rivers, MIBuilt 1977 · S/N 17269189 N734XKEllig Todd L · Horace, NDBuilt 1977 · S/N 17269195 N734XLWalsh Patrick Sean · Osterville, MABuilt 1977 · S/N 17269196 N734XMTri Star Cac LLC · Plano, TXBuilt 1977 · S/N 17269197 N734XPDutcher John A · Cedar Falls, IAS/N 17269199 N734XQSumter County Sheriffs Office · Sumter, SCBuilt 1977 · S/N 17269200 N734XSCrabtree Clifford I · Ukiah, CABuilt 1977 · S/N 17269202 N734XTFlying Colors Airparts Inc · Leesburg, FLBuilt 1977 · S/N 17269203 N734XXHuerta Holdings Inc · Santa Ana, CABuilt 1977 · S/N 17269207 N734XYBend Aircraft Mechanics LLC · Bend, ORBuilt 1977 · S/N 17269208 N734YALuxair LLC · College Station, TXBuilt 1977 · S/N 17269210 N734YBHrbk LLC · Grandview, INBuilt 1977 · S/N 17269211 N734YCShaw Terry R · Olympia, WAS/N 17269212 N734YDWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17269213 N734YLTactical Integrated Training Solutions LLC · San Antonio, TXBuilt 1977 · S/N 17269220 N734YMStockbridge Valley Flying Club Inc · Syracuse, NYBuilt 1977 · S/N 17269221 N734YVHarvey David C · Wellsboro, PABuilt 1977 · S/N 17269229 N734YXKvalita John C Jr · Port Charlotte, FLBuilt 1977 · S/N 17269231 N734ZAHanson Brian · Sauk City, WIBuilt 1977 · S/N 17269234 N734ZCGeorges Aviation Services Inc · Honolulu, HIS/N 17269236

Back to AD 79-10-03 R2