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.

N136TBColwell Paul · Scottsdale, AZBuilt 2001 · S/N E-3419 N136TCWeis Samuel K · Madera, CABuilt 1979 · S/N EA-15 N136TPSchacher Daniel E · Muleshoe, TXBuilt 1977 · S/N E-1176 N136TRRv6a136tr LLC · Merrillville, INBuilt 2000 · S/N 34132 N136TVReid Brian M · Boise, IDBuilt 1958 · S/N 51388 N136VPWartman Steven · Sandia Park, NMBuilt 1965 · S/N 28-21128 N136VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281193 N136XNautical Skies LLC · Helena, MTS/N D-6215 N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991 N137Bigfoot Aviation LLC · Saint Michael, MNBuilt 1960 · S/N 310-0028 N13701M-A-R-S Aircraft Leasing LLC · Williamsburg, VABuilt 1974 · S/N 17262953 N13703Kisser Carroll P · Alexandria, VABuilt 1974 · S/N 17262955 N1370ESprocket Aircraft Management LLC · Kennesaw, GABuilt 1978 · S/N 17270972 N1370QEvans Randall B Trustee · Fallon, NVBuilt 1977 · S/N 18503480 N1370SGolfbanks Leasing Partnership · Geneva, INBuilt 1976 · S/N 18264933 N1370UUnited States Air Force Aero Club · Usaf Academy, COBuilt 1976 · S/N 17267041 N13710Registered aircraftBuilt 1976 · S/N 17702456 N13715Wingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17262962 N13719Precious Metal Aviation LLC · Menomonee Falls, WIBuilt 1974 · S/N 17262966 N1371GFall Gregory F · Hanson, MABuilt 1976 · S/N 310R0725 N1371JSajko Gary · Chesapeake, VABuilt 1975 · S/N 371 N1371TSaviortree House Ministries · Coarsegold, CABuilt 1972 · S/N 28-7225485 N1371UStanton Sport Aviation · Stanton, MNBuilt 1976 · S/N 17267042 N13721Muth Robert F · Whitefish, MTBuilt 1974 · S/N 17262968 N13723Johnson Darwin E Jr Trustee · Hollywood, ALBuilt 1974 · S/N 17262970 N13725Moster Paul C · Morristown, NJBuilt 1974 · S/N 17262972 N13727Ofarrell Scott A · Sterling Heights, MIBuilt 1974 · S/N 17262973 N1372ECsa Aircraft Leasing LLC · Park City, UTS/N 17270974 N1372TGriffin Justin B · Hayesville, NCBuilt 1982 · S/N 83 N1372UFerguson Joseph L II · Fairmont, WVBuilt 1976 · S/N 17267043 N1372VBoland Matthew S · Anchorage, AKS/N U20602588 N13731East Derrick A · Cullman, ALBuilt 1974 · S/N 17262977 N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462 N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1373FBaczewski Gary L · San Antonio, TXBuilt 1975 · S/N 18502837 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N1373WGarces Manuel E · Jefferson, GABuilt 1963 · S/N 2654 N1373ZHoitt Edward D Jr · Deerfield, NHBuilt 1961 · S/N TD-479 N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465 N13741Rasmussen Tyler R · Independence, IAS/N 17262987 N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466 N13748Ries Farms LLC · Hastings, MNS/N 17262989 N13749Son Of Jubal Ministry LLC · Bainbridge, GAS/N 17702467 N1374EKjeldgaard James K · Fremont, NEBuilt 1978 · S/N 17270976 N1374JE2a Distributors Inc · Monroe, GABuilt 1975 · S/N 374 N1374SRenninger Log Homes · Meeker, COS/N 18264936

Back to AD 2007-04-19 R1