OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,915

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
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.

N459BBSanchez Frederick A · Lancaster, CABuilt 1968 · S/N 28R-30533N459WEPoppe Stephen · Grants Pass, ORBuilt 1968 · S/N 28R-30530N45JLBows Investments LLC · Bend, ORS/N 39-148N45MBWright Kelly A · Spokane, WABuilt 1959 · S/N 24-1445N45MTTimp Trails Ltd LLC · Orem, UTBuilt 1977 · S/N 347770233N4601JHardin John M · Terrell, TXBuilt 1968 · S/N 28R-30479N4602JNew Garden Township · Landenberg, PAS/N 28R-30481N4603JAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28R-30482N4604JTrouth Kevin J · Sulphur, LAS/N 28R-30483N4605JNichols James M · Duanesburg, NYS/N 28R-30485N4606JKantor Robert James · Rancho S Margarita, CABuilt 1968 · S/N 28R-30486N4607JHodgen Robert T III · Lexington, KYBuilt 1968 · S/N 28R-30487N4614JHendershot Kevin E · Owens Cross Roads, ALBuilt 1968 · S/N 28R-30494N4621JSudor Janet · Lancaster, PABuilt 1968 · S/N 28R-30506N4623JBrockway Jack E · Enumclaw, WABuilt 1968 · S/N 28R-30509N4624JCook Jerald W · Ariton, ALBuilt 1968 · S/N 28R-30510N4625JWhittington David D · So Ogden, UTBuilt 1968 · S/N 28R-30511N4626JMoonshiner Aviation LLC · Austin, TXBuilt 1968 · S/N 28R-30513N4628JSix Drew · Clinton, OHBuilt 1968 · S/N 28R-30515N4631JMiller Family Enterprises LLC · Humble, TXBuilt 1968 · S/N 28R-30518N4632JMckellar Todd R · Ridgecrest, CABuilt 1968 · S/N 28R-30519N4635JN4942d LLC · Greenfield, NHS/N 28R-30523N4637JVijayan Priya · Mckinney, TXBuilt 1968 · S/N 28R-30526N4638JChappel Dexter A · Palm Coast, FLBuilt 1968 · S/N 28R-30527N463RNDave Aviation LLC · Naperville, ILBuilt 1971 · S/N 28R-7135050N4641FCrosswinds Flying Club Inc · Bloomington, ILBuilt 1976 · S/N 28R-7635431N4641JN4641j LLC · Mulberry, FLBuilt 1968 · S/N 28R-30531N4645JHitchcock Scott B · Waco, TXBuilt 1968 · S/N 28R-30538N4646JCulley Johnny C · Amarillo, TXBuilt 1968 · S/N 28R-30539N4648JTutt Bryan · Louisville, KYS/N 28R-30542N4650JCrabtree Sandis · Jackson, OHBuilt 1968 · S/N 28R-30544N4651JReznik Real Estate LLC · Belton, SCBuilt 1968 · S/N 28R-30545N4653JHuffman Jacob M III · Burleson, TXBuilt 1968 · S/N 28R-30547N4655JCody Martell Racing Inc · Fort Myers, FLS/N 28R-30549N4656JPeters David E · Sylvania, OHBuilt 1968 · S/N 28R-30550N4657JHummel Aileen J · Fort Worth, TXBuilt 1968 · S/N 28R-30551N4662JBigby Calvin J · Savannah, GAS/N 28R-30558N4663JMetro Flying Club · Gilbert, SCBuilt 1968 · S/N 28R-30559N4664JDezelan Daniel · Fishers, INBuilt 1968 · S/N 28R-30562N4665FManzani Kelly · Temecula, CABuilt 1976 · S/N 28R-7635407N4665JBryant Kenneth W · Spring, TXBuilt 1968 · S/N 28R-30563N4666JBodie Charles H · Springfield, ORBuilt 1968 · S/N 28R-30565N4669JAirlake Aero Inc · Lakeville, MNBuilt 1968 · S/N 28R-30569N4671JBoklage Garnett H · Torrance, CABuilt 1968 · S/N 28R-30571N4672JBallard Shu Hui · Rancho Cucamonga, CAS/N 28R-30573N4675JRegistration Pending · Gardnerville, NVRegistration pendingBuilt 1968 · S/N 28R-30576N4681JRose Jeffrey R · Niceville, FLS/N 28R-30581N4682JAhz Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30561N4684JByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28R-30585N4685JGaither William W · Shallotte, NCBuilt 1968 · S/N 28R-30586
Back to AD 97-01-01 R1