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.

N7104PHill Chester · Bakersfield, CABuilt 1960 · S/N 24-2261 N7105PPruet Glen A · Richardson, TXBuilt 1961 · S/N 24-2262 N710MEQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-101 N7110PTobias Gregory L · Ottawa Lake, MIBuilt 1960 · S/N 24-2267 N7110YFaust Stanley J · Nashua, NHBuilt 1963 · S/N 30-129 N7111YBritt Robert J · Au Gres, MIBuilt 1963 · S/N 30-130 N7112PNouri Kamyar · Fullerton, CAS/N 24-2269 N7113PWallace Lonnie Roy · Charlotte, NCBuilt 1960 · S/N 24-1879 N7114PP & G Aviation LLC · Omaha, NEBuilt 1960 · S/N 24-2272 N7114YAymerich Marc · Belvedere, CABuilt 1963 · S/N 30-135 N7115YMcdade Nimrod R III · Smyrna, TNBuilt 1963 · S/N 30-136 N7116YSinclair Air LLC · Shallowater, TXBuilt 1963 · S/N 30-77 N7117PRegistration Pending · Sandia, TXRegistration pendingBuilt 1960 · S/N 24-2275 N7118PSuarez Aaron M · La Habra Heights, CAS/N 24-2276 N7119YFlydunn.Com Inc · Jacksonville, FLBuilt 1963 · S/N 30-138 N711ABL J S Enterprises Inc · Albany, TXBuilt 1969 · S/N 28R-35189 N711ANFlying Mermaid LLC · Aiea, HIBuilt 1975 · S/N 34-7570156 N711BAPresley Louis · Cresson, TXBuilt 1968 · S/N 24-4801 N711BWQualitair LLC Trustee · MichelstadtBuilt 1969 · S/N 24-4877 N711CVSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 28R-7135212 N711DLPalm Beach Flight Training Corp · Lantana, FLS/N 34-7350241 N711EEBrunson Douglas H · Burnet, TXBuilt 1978 · S/N 24-4596 N711EWWard Lumber Company Inc · El Cajon, CABuilt 1961 · S/N 24-2942 N711GCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1975 · S/N 34-7570053 N711KKRegistered aircraftBuilt 1969 · S/N 30-1870 N711SGGullo Santo · Ponce Inlet, FLBuilt 1966 · S/N 30-1300 N711TANorth Star Equipment LLC · Simms, MTBuilt 1958 · S/N 24-481 N711TYTas Technical Consulting Inc · Schaumburg, ILS/N 28R-7703025 N711WQMerrill Aviation LLC · Anchorage, AKBuilt 1975 · S/N 34-7570183 N7120YRoyal Ryan M · Lincoln, NEBuilt 1963 · S/N 30-139 N7121YUhlemeyer William A · Alvin, TXBuilt 1963 · S/N 30-140 N7122YSutton Jack M · Jesup, GABuilt 1963 · S/N 30-141 N7123PMclenaghan Alvain N · Phoenix, AZBuilt 1961 · S/N 24-2283 N7124PTalley John T · Clifton, TXFirst renewal noticeBuilt 1961 · S/N 24-2284 N7125PHernandez Jimmy Lee · Lamesa, TXBuilt 1961 · S/N 24-2286 N7126GHenry Rolla G Jr · Saint Charles, MOBuilt 1966 · S/N 30-1001 N7127YSpencer Avionics Inc · Spencer, IABuilt 1963 · S/N 30-148 N7128PRegistered aircraftBuilt 1961 · S/N 24-2291 N7128YAir Mods And Repair Corp · Robbinsville, NJBuilt 1963 · S/N 30-149 N7129YButner Gary W · Yuba City, CABuilt 1963 · S/N 30-151 N712PWDown The Creek LLC · Grant Valkaria, FLBuilt 1976 · S/N 32R-7680276 N7130PRieman Joel · Lompoc, CABuilt 1960 · S/N 24-2294 N7130THeffron Jacob L · Little Falls, MNFirst renewal noticeBuilt 1958 · S/N 24-598 N7131YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-153 N7132PJordan Kevin · Lander, WYBuilt 1961 · S/N 24-2297 N7134PHayduk International LLC · Rockhill Furnace, PAS/N 24-2299 N7135CBoss Gary W · Bronston, KYS/N 24-2300 N7136FCms Utility Services Inc · Punta Gorda, FLS/N 34-7770053 N7136YSchilling Stephen V · Rockford, ILBuilt 1963 · S/N 30-158 N7138PHickman Marcus · Fort Worth, TXBuilt 1960 · S/N 24-2303

Back to AD 97-01-01 R1