Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N1305AAir Dakota Flite Inc · Hettinger, NDBuilt 1951 · S/N 18-1109 N1305BTriangle Aviators LLC · Cary, NCBuilt 2007 · S/N 172S10654 N1305JMans Thomas S · Oakland, TNBuilt 1975 · S/N 305 N1305PParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1955 · S/N 23-345 N1305ZReynolds James Patrick · Lebanon, TNBuilt 1961 · S/N TC-119 N13061Kelly Thomas E · Tequesta, FLFirst renewal noticeBuilt 1975 · S/N 17702396 N13065Pacific Flight Academy LLC · Honolulu, HIBuilt 1973 · S/N 17262471 N13069Tabib Re · Winchester, CABuilt 1973 · S/N 17262472 N1306CWateractive43 LLC · Auburn, CABuilt 2007 · S/N 172S10655 N1306GCitadel Engineering Inc · Ellendale, DEBuilt 1974 · S/N 310Q1148 N1306MFreedom Aviation Inc · Lynchburg, VABuilt 2006 · S/N 172S10336 N1306W06 Whiskey Partners · Centennial, COBuilt 1963 · S/N 194 N1307Brian Michael L · Greensboro, NCBuilt 1969 · S/N TC-1307 N13076Smith Jimmy R · Bowling Green, KYBuilt 1973 · S/N 17262477 N13077Raborn Albert F · Collinsville, VABuilt 1973 · S/N 17262478 N13078Nichols Patrick C · Fairview, NCBuilt 1973 · S/N 17262479 N13079Great Lakes Air Inc · Alpena, MIBuilt 1973 · S/N 17262480 N1307CHouse Of Raeford Farms Inc · Rose Hill, NCBuilt 2006 · S/N 172S10337 N13081Eagle East Aviation Inc · North Andover, MABuilt 1973 · S/N 17262481 N13083Cloud Surfer N13083 LLC · Helena, MTBuilt 1973 · S/N 17262483 N13084Lutz Kelly L · Auburndale, FLBuilt 1976 · S/N 17702397 N1308BHopewell Jeffrey D · Temple, TXBuilt 1955 · S/N 23-340 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 N1308SCecil Donald C · Willows, CABuilt 1976 · S/N 18264873 N1308ZDelaney Troy · Lake Ozark, MOBuilt 1961 · S/N D-6743 N13093Multiflight II Inc · Lakeville, MNBuilt 1973 · S/N 17262488 N13095Air Ally Asset Management LLC · Chisago City, MNBuilt 1973 · S/N 17262489 N13096Flights Cool LLC · La Conner, WABuilt 1973 · S/N 17262490 N13099Steeber Pauline M · Mcmurray, PABuilt 1973 · S/N 17262493 N1309GPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10342 N1309MReny Donald Cyril Jr · League City, TXBuilt 2008 · S/N 18282050 N1309SBlackburn Mark R · Saint Paul, KSBuilt 1976 · S/N 18264874 N1309U129w Holdings LLC · Terlingua, TXBuilt 1976 · S/N 17266999 N1309WSanford Mark J · Ithaca, NYBuilt 1963 · S/N 197 N1309ZReady Aim Flyer LLC · New Castle, DEBuilt 1961 · S/N TD-463 N130ACBilco Air LLC · Danville, ILBuilt 1992 · S/N 663-92 N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578 N130BBHatfield Derik L · Mesa, AZBuilt 1979 · S/N 0013 N130BNJch Aviation LLC · Midlothian, TXS/N 20110 N130BRWilcox Charles R · Discovery Bay, CABuilt 2005 · S/N 2920 N130BYCabe Robert D · San Antonio, TXBuilt 1999 · S/N 2 N130BZEvans Robert G · Choctaw, OKBuilt 2002 · S/N 21316 N130CFFlying C Leasing Ltd · Wilmington, DEBuilt 1977 · S/N 15279509 N130DGDixie Aviation LLC · Pelham, ALBuilt 1972 · S/N 28R-7235127 N130DPPlane@Work LLC · Blaine, MNBuilt 1987 · S/N 003 N130EOshinuga Anthony A · Valley Center, CABuilt 1940 · S/N 1029 N130ERSale Reported · Freeburg, PASale reportedS/N 1511 N130GHBose Tamal · Tucson, AZBuilt 1965 · S/N 32-124 N130GWBruckner Peter J · Rochester, NHBuilt 1975 · S/N AA50707 N130GYRobinson Stewart · San Jacinto, CABuilt 1993 · S/N 2239

Back to AD 2007-04-19 R1